Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trap #Div/0 in conditional formatting
is it possible to detect the #Div/0! text / error in conditional formatting,
so that if it appears, due to empty cells else where in the sheet, I can set the font colour to the same as the background colour to hide it? I tried using an 'If' statement to detect empty cells, then not using the formula if any were empty, but my users need to edit the formula to suit their needs, and don't have the knowledge to use the 'If' statement. Any help appreciatted. Thanks Neil |
#2
|
|||
|
|||
is it possible to detect the #Div/0! text / error in conditional
formatting, How about =ISERROR(C1) , where C1 is the #DIV/0! cell. HTH, Andy |
#3
|
|||
|
|||
Hi
in the conditional format dialog enter =ISERROR(cell_reference) to check for an error condition "Neil" wrote: is it possible to detect the #Div/0! text / error in conditional formatting, so that if it appears, due to empty cells else where in the sheet, I can set the font colour to the same as the background colour to hide it? I tried using an 'If' statement to detect empty cells, then not using the formula if any were empty, but my users need to edit the formula to suit their needs, and don't have the knowledge to use the 'If' statement. Any help appreciatted. Thanks Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in Charts? | Charts and Charting in Excel | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |