Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format - table - cell empty return default color
I inserted a table with alternating colors. I don't see the formatting code - it's a table feature.
I format the background of any particular cell based on whatever. Problem is I can't figure out to return the default color on isblank(). How do you do that? I get a white or certain color background no matter what formatting I select. I have this feeling that as soon as you enter formatting rules, Excel puts it's own on hold. My table alternates blue, white, blue ... row to row. It's just a standard table type Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format - table - cell empty return default color
On Monday, February 17, 2014 4:07:11 PM UTC-6, wrote:
I inserted a table with alternating colors. I don't see the formatting code - it's a table feature. I format the background of any particular cell based on whatever. Problem is I can't figure out to return the default color on isblank(). How do you do that? I get a white or certain color background no matter what formatting I select. I have this feeling that as soon as you enter formatting rules, Excel puts it's own on hold. My table alternates blue, white, blue ... row to row. It's just a standard table type Thanks Can't be done. Excel surrenders its formatting as soon as you pick it up. I had to do the mod 2 trick. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I override conditional format to modify color of 1 cell? | Excel Discussion (Misc queries) | |||
Conditional format a cell based on color of another | Excel Discussion (Misc queries) | |||
Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
Conditional format : return to default format | Excel Programming | |||
Conditional Format? - color if cell is modified by user | Excel Programming |