I have a rather complicated problem I'm trying to solve.
I have 8 columns of data with various numbers of rows. I would like to compare all 8 columns and only highlight those cells in which the text appears in all 8 columns.
That's the first process I would like to do.
Then, in a separate sheet, I would like to highlight those that occur in 7 out of 8 columns, then 6 out of 8, etc.
I'd greatly appreciate it if someone could help.
In response to your first process, let's say that your data is from A2:H6 (headers in row 1).
Assuming that you want to highlight a row when all of the cells in that row have any value, try this:
Highlight A2:H6 > Conditional Formatting > New Rule > Use a formula
=COUNTA($A2:$H6)=8
Format: Fill color of your choice > OK > OK
If you only want to highlight a row when all 8 values are the same, you can use this CF formula instead:
=COUNTIF($A2:$H2,$A2)=8
Last edited by 63falcondude; 06-16-2017 at 02:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks