N
Niall
Hello All,
This may have been covered by previous topics, but I could not see it.
I want to apply 3 different conditional formats to a column where the
cells have a formula applied as follows:
=IF(Q11>=5,"1",IF(Q11>=4,"2",
IF(Q11>=3,"3",IF(Q11>=2,"4",IF(Q11<2,"5"))))), Q being a column where a
SUM is calculated.
The conditions I want are RED for value >=5, ("1"); ORANGE for value
When I apply the conditional formatting it only appears to work where I
use 'Formula is'. And then it will only apply one condition, i.e. the
higher value. I have tried using 'Cell value is' and putting in both
the presented value, i.e. within the quote marks of the IF argument,
and the calcualted value, i.e. the value range from the SUM column.
Any ideas would be greatly appreciated
Regards,
Niall
This may have been covered by previous topics, but I could not see it.
I want to apply 3 different conditional formats to a column where the
cells have a formula applied as follows:
=IF(Q11>=5,"1",IF(Q11>=4,"2",
IF(Q11>=3,"3",IF(Q11>=2,"4",IF(Q11<2,"5"))))), Q being a column where a
SUM is calculated.
The conditions I want are RED for value >=5, ("1"); ORANGE for value
=4, ("2"); and YELLOW for value >=3, ("3").
When I apply the conditional formatting it only appears to work where I
use 'Formula is'. And then it will only apply one condition, i.e. the
higher value. I have tried using 'Cell value is' and putting in both
the presented value, i.e. within the quote marks of the IF argument,
and the calcualted value, i.e. the value range from the SUM column.
Any ideas would be greatly appreciated
Regards,
Niall