Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi, I am using Excel 2003 and I would like to know has anyone used
conditional formatting with a named range? I have a named range called City. What I would like to do is highlight the rows when the city changes, continue to highlight when I use the filter command. This command works well when I use no filters: $b16<$b15 How can I get it to work when I filter out records? Maybe through VBA which I am still learning. Thanks for all your help! John :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |