i Think I need some help with conditional formatting

  • Thread starter Thread starter seftonbarn
  • Start date Start date
S

seftonbarn

I am a bit of a novice so please forgive me if this is a very basi
posting. I have a number of columns and at the top of each there is
date. I would like the whole of the cloumn to be shaded grey if tha
date is either a Saturday or a Sunday. Any ideas??
 
Hi
if you want to aply this for example to the columns A:F try the
following:
- select column A:F
- goto 'Format - Conditional Format'
- enter the following formula
=WEEKDAY(A$1,2)>=6
- choose your format
 
Use:

Formula is: =OR(WEEKDAY(C$1)=1,WEEKDAY(C$1)=7) in Column C and set a
suitable format

Regards

Trevor
 
Back
Top