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
Bookmarks