#1   Report Post  
Natalie
 
Posts: n/a
Default page colour

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   Report Post  
LanceB
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
print selected sections on the same page ripley Excel Discussion (Misc queries) 1 February 22nd 05 04:04 PM
Problems with Colour Printing Aussie CPA Excel Discussion (Misc queries) 1 February 18th 05 12:03 AM
How do I keep page breaks for each page in a sheet without the co. notexcellent Excel Discussion (Misc queries) 0 February 9th 05 07:53 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"