How do I proceed with let us assume I have two options in a drop-down list Yes or No For yes- I need to columns 4 column until something is written onto them For no- I need to provide Not applicable to all the four columns.
@LANCASTERESL
6 жыл бұрын
How can I use apply conditional formatting Greater than 3.5 ? I cannot get CF to work with decimals.
@x68507
6 жыл бұрын
To see if a value is greater than 3.5, you can simply use "=A1>3.5". Make sure to include the equal sign at the beginning to tell Excel that the condition you are trying to compare is a formula. The data that you have might be stored as text rather than numbers, so you can also try to modify the formula slightly with the VALUE() method; the formula will then look like "=VALUE(A1)>3.5"
Пікірлер: 3