- Highlight Cell Question
- Excel VBA - Change cell color based on value (Solved) » Forum - Programming
- Excel - - Highlight cell if no data » How-To - Excel
- Excel - Assign Macro to all yellow highlighted cells » How-To - Excel
- Excel - Highlighting cells based on days » How-To - Excel
- Pls help - Excel - Highlight cell if no data [Solved] (Solved) » Forum - Excel

Try to use:

Select

1st RULE

Conditional Format --> Using formula --> =A3>B3

--> Format: Fill color as GREEN

OK

2nd RULE

Conditional Format --> Using formula --> =A3<B3

--> Format: Fill color as RED

OK

Please, tell us if it worked as you desired.

I hope it helps.

Report
Respond to DParson55

That worked indeed. Thank you. One last piece that I neglected to mention, what would the formula be to highlight C3 green in the event that A3 and B3 were equal?

Simply change the first rule.

1st RULE

Conditional Format --> Using formula -->

--> Format: Fill color as

OK

I hope it helps

--

Belo Horizonte,

Marcílio Lobão

What if I needed to make the "equal to" function yet a third color, say Yellow?

Got it. Thank you again for your help!

- Member requests are more likely to be responded to.
- Members can monitor the statuses of their requests from their account pages.
- A CCM membership gives you access to additional options.