Conditional formatting ignoring null values

Hi,

Im using Excel 2010 and i have managed to conditionaly format my cells based on the the column in front of it, however I don’t want the cell to condiotinally format if there is no data in it.

For example I have in column F a list of numbers and in column E a number of statuses ie (red, amber or green). Now I want the cells in column F to change colour based on the status but i dont want the cell to change colur if there is not a value present in the cell in colum F. Can anyone help with this?

In the example below i want the cells with the numbers 10, 5 and 12 to turn their respective colours but i dont want the empty cell to turn green.

e.g.

Column E F
Green 10
Red 5
Green
Amber 12

Many thanks in advance.

In conditional Format go to "Manage Rules", then click on "New Rule". Once you've done this select "Use a formulae to ..."

Now put this code in

=IF(F1="",TRUE,FALSE)

Then you just need to format this to a blank format. Click the stop when true selection box and that should do it for you

Any questions then let me know

Fantastioc Jockeny - thats done the trick, thank you very much.

You're welcome