If any value in the R column is unique, and not repeated anywhere else in the column (don't care about the rest of the worksheet) then highlight the row red.
If any value in the R column is unique, and not repeated anywhere else in the column (don't care about the rest of the worksheet) then highlight the row red.
Try:Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Select all the columns you want highlighted and then use the Conditional Format formula:Formula:Please Login or Register to view this content.
Note: for this to work correctly, it must be applied to all rows from row 1 down. If, for example, you want to exclude a header row, you would use, for example:You may need to adjust the last row number up from 1000.Formula:Please Login or Register to view this content.
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
Sorry, didn't notice you wanted a VBA solution. May I ask why you want/need VBA?
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks