Hi,
I need some help in conditional formatting. I have attached a spread sheet to show what I want.
I have two columns Points A and Points B. I want to conditional format Points A column with the following criteria.
GREEN if number in Points A "greater" than Points B.
Amber if number in Points A "Equals" Points B.
RED if number in Points A "less" than Points B.
Regards,
Raj
You actually need three rules.
Select the values in column A from cell A2 down to the last row
The first, for red, would be: =$A2<$B2
The second, for amber, would be: =$A2=$B2
And the third, for green, would be: =$A2<>$B2
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi rajys
See attached for the conditional formatting in place and the rules.
Kevin
Thats exatly what I wanted. Kevins method works. Thank you both.
Cheers,
Raj
Hi rajys
Thanks for the feed back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks