Changing cell colour

[tomwells]

Is it possible to change the cell colour(fill) in an IF function?
I.E
IF(A2<0,cellcolour(red),cellcolour(blue))
logic, value if TRUE, value if FALSE

Thanks

 

[texasalynn]

no not with an IF statement but take a look at conditional formatting

texasalynn

 

[Smitty]

Welcome to the Board!

Yes. Look at Format-->Conditional Formatting-->If Cell Value is-->Less than-->0-->Set format, then select Add and repeat for the second criteria.

Hope that helps,

Smitty

 

[tomwells]

Thankyou, it looks promising.