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.

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.

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(C17,1if(C1<7,2,if(C1<=0,3,"What ever")))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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.