| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting with multiple, non-consecutive values??
You might try highlighting the column, then use "Edit" "Replace" to replace
any blanks with nothing. "David in VB" wrote: RagDyer and David B, Yep, I have Excel 2007. I'm pretty sure I was able to choose "formula is" but still no dice. I went to "format values where this formula is true" then entered the formula you provided. I tried the double quotes, too. The zip codes aren't text, they're simply 5-digit numbers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
| conditional formatting consecutive cells | Excel Worksheet Functions | |||
| Conditional Formatting for multiple values | Excel Discussion (Misc queries) | |||
| Conditional formatting on Consecutive cells | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
Threaded Mode
