Conditional Formatting

  • Thread starter Thread starter Eán
  • Start date Start date
E

Eán

Hi
Help please
I have entered the following formula into my conditional formatting boxes,
formula is:
C1>7,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.
 
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))
 
Hi,

Conditional formatting can only assist you with formatting cells and not
returning a certain output. Therefore, if you would like 1,2,3 to appear in
the cell, then write the formula in the cell instead of Format > Conditional
Formatting. Therefore, in cell C1, the formula would be

If(C1>7,1if(C1<7,2,if(C1<=0,3,"What ever")))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top