Hi All, I wonder if you can help. Im trying to match information in column A against information in column H, if it matches I would to highlight the cell in a colour. I was thinking of using index match but wasnt sure if this was the best formula and I dont know how to add in the coloured cell part. Please take a look at my test page (attached). For this test Its clear that H9 matches A2, so I want H2 to be coloured. Thanks for your help in advance.
If you just want to know if it exists in the H column, you can use COUNTIF or COUNTIFS. You would use the formula in Conditional Formatting to add the colour.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks