Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am setting up a very simple, one-step, conditional format to hide a cell if
it is displaying an error. The formula is: =iserror(relative cell ref) The format is: font color = white I then try to copy those cells, but the whole range turns white. I then cannot even manually adjust the font color for those cells, as they still render as white. And oddly even if I manually retype the whole conditional formatting (in a cell where I attempted to copy the conditional formatting) it still won't render properly. I have to delete the conditional formatting, and then retype. Can anyone give me some pointers? Thanks, -b |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting a range of cells. | Excel Discussion (Misc queries) | |||
Copying Conditional Formatting to multiple cells | Excel Discussion (Misc queries) | |||
Conditional formatting a range of cells | Excel Worksheet Functions | |||
Conditional formatting for range of cells? | Excel Worksheet Functions | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) |