Format one cell based on relationship of two different cells??

Mr. L

New Member
Joined
Jul 29, 2010
Messages
2
Here is an example...

Format A2 if B2 is > C2

I would like to have different colors for "=" ">" "<"

Can anyone help?

Thanks!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Mr. L

New Member
Joined
Jul 29, 2010
Messages
2
Thanks for the welcome..

I think I have figured it out... Thanks for your time.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,084
Messages
5,526,755
Members
409,717
Latest member
Oscarsalone

This Week's Hot Topics

Top