Excel 2003 - conditional formatting not ignoring blank cells

[Lloydiesuk]

Hi,

I am using conditional formatting to colour cells dependent on the formula result within the cell.

it is table showing average quality audit scores per month where they can score a maximum 5 for each audit question.

green - greater than or equal to 4.5
amber - between 3 and 4.5
red - less than 3

I have an IF formula entered to blank the cell where the formula result is 0 (i.e. no audit results have been entered) - '=IF(C30>0,C30,"")' however the cell coilour is changing to green when the desired result would be no colour.

Hoping someone can help!!

Thanks

[Pepe Le Mokko]

Hi
to XL "" is a null string and considered as text. Text is always larger than a number ( XL always compares the TYPE before the value). That is why you get green
Perhaps change it to =IF(C30>0,C30,0) and uncheck "zero values " in the View Tab of XL 2003 options ( if you use 2003 as indicated)
If you are using a post 2003 version add a CF and place it in the last position of the conditions

[Lloydiesuk]

Excellent - worked perfectly - many thanks..