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

@Snafu_2505 
yes,
use conditional formatting to do so 
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...

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

harshulz_0-1646878586041.png

formatting cell will make colors you need