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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
hi chequer
select the first of your cells where you want to have the conditional formatting in your case i think it's L8, then you go to "Format" - "Conditional Formatting..." there you enter: "Formula is: =iserror(L8)" Important, don't enter the Dollar signs! Then you can take the format-Brush (i don't know how it's called, but the Icon looks like a brush and you can copy formats with it.) And select all the other cells. Hth Cheers Carlo "chequer" wrote: ,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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
Thanks Carlo,
That worked fine on all but 'FALSE' and zeros. I got rid of the zeros by using: Cell value is equal to 0 I have to go into hospital tomorrow so If you reply it will be about a week before I can answer. -- chequer "Carlo" wrote: hi chequer select the first of your cells where you want to have the conditional formatting in your case i think it's L8, then you go to "Format" - "Conditional Formatting..." there you enter: "Formula is: =iserror(L8)" Important, don't enter the Dollar signs! Then you can take the format-Brush (i don't know how it's called, but the Icon looks like a brush and you can copy formats with it.) And select all the other cells. Hth Cheers Carlo "chequer" wrote: ,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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format
Hi chequer
hope you'll be fine, after the hospital! if you want to include FALSE and ZEROS, you could use following formula: "Formula is: =OR(ISERROR(L8);L8 = False; L8 = 0)" Hope that helps Greetings and hope you get well soon Carlo "chequer" wrote: Thanks Carlo, That worked fine on all but 'FALSE' and zeros. I got rid of the zeros by using: Cell value is equal to 0 I have to go into hospital tomorrow so If you reply it will be about a week before I can answer. -- chequer "Carlo" wrote: hi chequer select the first of your cells where you want to have the conditional formatting in your case i think it's L8, then you go to "Format" - "Conditional Formatting..." there you enter: "Formula is: =iserror(L8)" Important, don't enter the Dollar signs! Then you can take the format-Brush (i don't know how it's called, but the Icon looks like a brush and you can copy formats with it.) And select all the other cells. Hth Cheers Carlo "chequer" wrote: ,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 |
Reply |
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 |