LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default CONDITIONAL FORMATING!!!!!

I hava a worksheet that a fill up completely but sometimes I do not have all
the require information and I need to go back to it. What I need is a
conditional formating to color the whole sheet but when I write anything
including numbers or text or dates the color disapear, that way I'll find
easy to find the part that I did not fill up ( for ex. it will be blue). The
worksheet is from A1 to G1 across and from A1 to A45 down. Tx
 
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
conditional formating Paul Excel Discussion (Misc queries) 1 September 21st 06 09:28 PM
Conditional Formating Haiggy Excel Worksheet Functions 3 June 20th 06 04:11 PM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
Conditional Formating Roy Excel Discussion (Misc queries) 4 May 27th 05 01:16 AM
Conditional Formating bell7526 Excel Discussion (Misc queries) 2 May 25th 05 10:05 PM


All times are GMT +1. The time now is 05:14 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"