Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
I have a sheet that has approx 7,000 rows.
Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some conditional formatting to hide this error values, does anyone know how I can do it? TIA, _Bigred |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
Select entire sheet (with A1 active), and apply the CF as
Condition 1: =ISERROR(A1) Format the font color white (to mask) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "_Bigred" wrote: I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some conditional formatting to hide this error values, does anyone know how I can do it? TIA, _Bigred |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
One way:
Conditional Formatting | Formula is: =ISERROR(cell) =ISERROR(L21) (for example) Format the font to be white (or the same as the background colour in the cell) Regards Trevor "_Bigred" wrote in message ... I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some conditional formatting to hide this error values, does anyone know how I can do it? TIA, _Bigred |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
Condition 1: =ISERROR(A1)
Just to clarify that the above line refers to the "Formula Is" option for condition 1 .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
You've got two answers giving solution exactly as you asked for it: via
conditional formatting. I'll offer a different solution: back in your formula itself! Lets say you have a formula like this: =A1/A2 and it's giving you a #DIV/0! error because nothing is in A2, you could change that to =IF(ISERROR(A1/A2),"",A1/A2) and that would suppress display of the any error notations also. See Excel help on ISNA(), ISERR() and ISERROR() - each works slightly different, with ISERROR() detecting any type of error. If you're unfamiliar with the IF() function, has 3 parts: condition what to do if condition is true what to do if condition is false each of the 3 parts is separated by a comma. "_Bigred" wrote: I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some conditional formatting to hide this error values, does anyone know how I can do it? TIA, _Bigred |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
Thanks Max, worked like a charm!
_Bigred "Max" wrote in message ... Select entire sheet (with A1 active), and apply the CF as Condition 1: =ISERROR(A1) Format the font color white (to mask) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "_Bigred" wrote: I have a sheet that has approx 7,000 rows. Until I get all the data into it many columns will contain: #DIV/0! or #VALUE! I would like to do some conditional formatting to hide this error values, does anyone know how I can do it? TIA, _Bigred |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem conditional formatting?
You're welcome, Bigred !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "_Bigred" wrote: Thanks Max, worked like a charm! _Bigred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting problem | Excel Discussion (Misc queries) | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Conditional Formatting Problem | Excel Discussion (Misc queries) |