Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would like to use conditional formatting for 4 or more items.
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 | |
|
|
Similar Threads | ||||
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) |