Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
How do I set all the pages to be blue?
I need them to stay blue if rows are added etc. Is there a way to make the conditional formatting equal to blank cells? |
#2
![]() |
|||
|
|||
![]()
Format!Conditional format|formula is: =isblank(a1)
However any entry into the cell will remove the condition Format!Conditional format|formula is: =true Will establish a condition that is always true and the formatting will be applied or you could just set the the pattern to blue in format cells Lance "Natalie" wrote: How do I set all the pages to be blue? I need them to stay blue if rows are added etc. Is there a way to make the conditional formatting equal to blank cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
print selected sections on the same page | Excel Discussion (Misc queries) | |||
Problems with Colour Printing | Excel Discussion (Misc queries) | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
excel 2003 page numbering | Excel Worksheet Functions |