Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have item #s I would like to show up a certain color if they meet certain
conditions. EG. My list starts in BQ3 and can have 30 varying #s. I would like the conditional formatting to color the items only if the alpha,numeric # matches one of 4 in another list starting in BR12. The #s are random, PROX 30000 OR TILX 310245 so I cannot use the between or < rules. And, conditional formatting only allows 3 rules. Any ideas? Thanks, Inge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |