![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
|
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.
|
|
|
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 |