Conditional Formatting
Hi
Conditional Formatting will only change the attributes of a cell, not the
values within the cell.
You would have to use a column alongside with a formula
=IFC1<=0,3,IF(C1<7,2,1))
--
Regards
Roger Govier
"Eán" wrote in message
...
Hi
Help please
I have entered the following formula into my conditional formatting boxes,
formula is:
C17,1
C1<7,2
C1<=0,3
So that the cell would then be given a 1, 2 or 3 rating - however, there
is
no output in my cell?
Am I doing this correctly or is there another way I could do this?
Many thanks in advance.
|