|
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
Conditional formatting formula to format cells not equal to a group value
Hello. Is there a conditional formula that will highlight a cell having a value that is not equal to the group. Like in the image, B4 and B10 should be formatted as different. The criteria is, the first name listed beside a number should be the name for all similar numbers. The first name in number 1 is AA so all names for 1 should be AA. Thank you.
|
#2
|
||||
|
||||
Conditional formatting in B2:B12 in the attached.
|
#3
|
||||
|
||||
Thank you! I had been dumbly looking at COUNTIF but resorted to helper columns of VLookup and True/False. I will now delete those in favor of the Index/Match.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to highlight the cells using conditional formatting? | LearnerExcel | Excel | 1 | 01-01-2019 01:43 AM |
Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu | AlanBird | Excel | 3 | 11-25-2017 03:11 PM |
Conditional Formatting for Cells Containing Formula | Gillian623 | Excel | 1 | 12-09-2016 11:03 PM |
Conditional Formatting- Only format cells once data is entered | chart3 | Excel Programming | 1 | 12-15-2015 11:26 AM |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |