| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Conditional formatting in 2007
In Excel 2003 there is a way to cause all conditionally formatted cells to
highlight in gray. It's to check if you've formatted all the intended cells without missing any. However I'm not sure how to do that in the 2007 version. Anyone know what I'm talking about? -- thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check Conditional formatting in 2007
I don't know how you did it in Excel 2003 but this will do it in any
version: Hit function key F5 SpecialConditional formatsOK -- Biff Microsoft Excel MVP "COB" wrote in message ... In Excel 2003 there is a way to cause all conditionally formatted cells to highlight in gray. It's to check if you've formatted all the intended cells without missing any. However I'm not sure how to do that in the 2007 version. Anyone know what I'm talking about? -- thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting to Check for Blanks | Excel Worksheet Functions | |||
| Conditional Formatting 2007 | Excel Worksheet Functions | |||
| how to check for ANY text when conditional formatting? | Excel Discussion (Misc queries) | |||
| check text color from conditional formatting w/out using VB | Excel Discussion (Misc queries) | |||
| Check box & conditional formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
