Highlight Column Based on Weekend Day

[orkt]

I would like to highlight a column (partial actually, say 15 rows) depending on if the 1st Row has a Weekend Date in it.

The first row would be something like:

3/12 -- 3/13 -- 3/14 -- 3/15 etc....
where 3/12 and 3/13 are weekend dates.
those column i would like to ?conditionaly format with a color, maybe 15 rows.

TIA

 

[AlphaFrog]

Formula is =WEEKDAY(A$1,2)>5

 

[Norie]

Select the range from the dates down.

Goto conditional formatting, select formula is or Use a formula (2010) and enter this formula:

=WEEKDAY(C$1,2)>5

and format as required.

You'll need to change C$1 to suit, for example if your dates are in row 5 and begin in column A you would use A$5.

 

[orkt]

Yes I understand that, thanks. However I wanted to highlight the column & 15 rows below the one which has the weekend day.

like..

friday saturday sunday monday
data1 data2.... data3.. data4..
data1 data2.... data3.. data4..
data1 data2.... data3.. data4..
data1 data2.... data3.. data4..
data1 data2.... data3.. data4..

etc...

TIA

 

[AlphaFrog]

Select all your data (all the columns you want to conditional format and the 15 rows). Lets say for this example that is C1 to J15

Then select Conditional Formatting from the menu and put in this formula

Formula is =WEEKDAY(C$1,2)>5

Where C$1 is the active cell of your selection.

Excel will automatically adjust the formulas for the other cells as needed

 

[orkt]

Thanks that worked great.

I used =WEEKDAY(A$1,2)>5, selected the range and applied the fill format I wanted.

I searched hi and low for this thanks for the seemingly simple & Quick fix