Hey guys,
I'm looking to do conditional formatting that highlights a certain section just as seen in the example when the first few characters match the first few of another column. If they match I'd like to highlight RED if they do NOT match then GREEN. Its a little backwards but what I'm eager to sort out. Any help is appreciated!
Thanks,
Excel2425
Green
=upper(left($b7,3))=upper(left($c7,3))
red
=upper(left($b7,3))<>upper(left($c7,3))
Select A7: N??? however many rows you want to go down
Then use conditional formatting rules
add a new rule, with formula
=LEFT($B7,3) = LEFT($C7,3) for Green
and a new rule with formula
=LEFT($B7,3) <> LEFT($C7,3) for red
to stop blank cells colouring - you can use and AND()
as below
=AND(LEFT($B7,3) = LEFT($C7,3) , $B7 <> "" ) for Green
=AND(LEFT($B7,3) <> LEFT($C7,3) , $B7 <> "" ) for red
see attached range from A7 to N100
Last edited by etaf; 01-19-2017 at 12:04 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Looks to have done just the trick! Thanks.
you are welcome , thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks