Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
,Office 2003. OS: WindowsXP SP2 Home edition.
I am trying to tidy up using Conditional Formatting, to blank out cells that contain such as, #VALUE, FALSE, #DIV! etc... I tried using: 1. Formula is =ISERROR($L$8:$AK$70) 2. Cell value is: between =ISERROR($L$8 and $AK$70) But couldnt get either to work. I know that I can blank out zeros with: cell value is equal to 0, zero I also tried highlighting the range of cells first I searched for it in Office online but couldn't find what I wanted.` -- chequer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Conditional format numbers | Excel Worksheet Functions | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional Format Question | Excel Worksheet Functions |