LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a conditional format that changes the number format tmbo Excel Discussion (Misc queries) 1 August 23rd 06 06:20 AM
Data Validation or Conditional Format (or combo of) Scott Excel Worksheet Functions 3 November 3rd 05 03:57 PM
Conditional format numbers PiPPo Excel Worksheet Functions 5 October 18th 05 05:03 AM
Cell Format Changes When Data Is Entered - Not Conditional Formatt SundanceKidLudwig Excel Worksheet Functions 2 September 30th 05 02:07 PM
Conditional Format Question DougS Excel Worksheet Functions 3 May 3rd 05 01:36 AM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"