Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2005

Tip: Looking for answers? Try searching our database.

Coloured rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sonic-the-mouse - 29 May 2005 14:45 GMT
Max & Don

Thanks for your assistance. I have opted for the variation provided by
Max as it worked first time.  Thanks again.

stm

Max Wrote:
> A variation of Don's suggestion ...
>
> If you have it set-up with the days in A2 down, i.e.:-
> Mon
> Tues
> Wed
> Thurs
> Fri
> Sat
> Sun-
> etc
>
> Press CTRL+A to select the entire sheet
> Click Format  Conditional Formatting
>
> Under Condition1, make the settings as:
> Formula is| =OR($A1="Sat",$A1="Sun")
> (Note that the dollar signs are important!)
>
> Click Format button  Patterns tab  Gray?  OK
> Click OK at the main dialog
>
> Entire rows with either "Sat" or "Sun"
> as the row headers in col A will be colored gray
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8,  1° 22' N  103° 45' E
> xdemechanik atyahoodotcom
> ----

Signature

sonic-the-mouse

Max - 29 May 2005 18:21 GMT
You're welcome !
Thanks for the feedback ..
Signature

--
Rgds
Max
xl 97
---
GMT+8,  1° 22' N  103° 45' E
xdemechanik <at>yahoo<dot>com
----

>
> Max & Don
[quoted text clipped - 3 lines]
>
> stm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.