use <format<conditional format formula is your if statement format green
use your if statement with a NOT in front with format red

"J. Kerr" wrote:

Is there a way to change the colour of the cell when using an IF statement.
ie: I would like to see the cell Green if it is TRUE and Red if it is FALSE