Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to create a conditional format that will look at 30 cells and if
any one of the cells matches the current cell it should change the color of the number. Example: Each cell contains the following number A B C D E 1 1 2 5 1 2 2 3 4 2 3 4 3 5 6 1 5 6 4 1 2 5 2 5 5 3 4 2 4 2 6 5 6 1 6 1 15 3 In cell A15 I would like a conditional format that would take the number in cell A15 and check to see if it is in the area of A1..E6. If there is one number that matches the number in A15 then I would like the number in A15 to change to a color, if not it remains unchanged. The numbers could be spread out throughout the spreadsheet so I would need to reference 30 specific cells not just the range. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formating based on other cells | Excel Worksheet Functions | |||
Conditional Formating based on a different cell | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Conditional Formating based on another cell | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |