Conditional Formatting in Excel

Occasional Contributor
I am trying to compare cells in different columns using conditional formatting. I was hoping someone could help me with creating my own formula.
For example: F3 turns red if it’s value (numbers) is less than E3 and F3 turns yellow if it is more than E3. If E3 and F3 values are equal, I want it to have no color indication.
I understand how to create the condition but I do not know how the formula should be written.

Please advise!
8 Replies

@senoi Perhaps easiest to demonstrate in a working example. See attached.

Screenshot 2021-06-08 at 06.06.45.png

Screenshot 2021-06-08 at 06.06.26.png


Is possible for you to show a screenshot of the formula you used to create your example?
best response confirmed by senoi (Occasional Contributor)




Thank you so much, I knew it was something simple
It didn’t work.

@senoi Better to open the file that I attached. It contains two ways of achieving the result you asked for. But if you insist on a screenshot, here it is.

Screenshot 2021-06-09 at 05.54.00.png

I tried opening the file, it came up only as like a screenshot. I will try again. I’m still learning and I’m new to the community. Thank you for your help.



When you click a file on here it opens a preview of the file that looks like an image.

To download the file click the highlighted 'download' button shown below.