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