Colourising the result of an IF function

Occasional Visitor

Is there a way changing the text or cell fill, in response to the test; if x<y then cell colour Green, if this is not the case then text or cell colour Red.


I am not an Excel expert!

1 Reply

use conditional formatting to do so

go to home>> under style tab>> conditional formatting>> select new rule


formatting cell will make colors you need