C/F assistance please (Excel 2003, SP3)

[steveh]

Morning all

I have a grid Columns B3:AF3 contain the current ddd-dd based on cell B1, rows A4 - A28 have times in 1/2 hour increments from 08:00 to 20:00 my intention is to use CF to highlight the weekend dates in the grid.

First attempt: Highlight B3:AF28 and in CF Formula is =WEEKDAY($B3,2)>5 and all of the grid turns Orange (my CF colour)

Second attempt: In B4 only =WEEKDAY($B3,2)>5 and then drag across to AF4 and it works OK, the weekend cells are highlighted but when I select B4:AF4 and drag it down row a4 still highlights the weekends but from row A5 down to A28 everything becomes highlighted.

I have tried various combinations with the same result each time. I can do it by going into A5 and typing the forumla in CF and dragging it across to AF5 but there must be an easier way than having to go to every row and type the formula in and dragging it across?

[StuartR]

Try removing the $ from $B3, and then your second attempt should work.

[HansV]

Try selecting B3:AF28 and using the formula

=WEEKDAY(B$3,2)>5

This makes the column variable, and the row fixed, i.e. the formula will always look at the dates in row 3, but adjust the column.

[steveh]

Good morning

Thanks Stuart, trying this it did the right thing in the header columns by highlighting the weekends but in the rest of the grid is completly fills the grid in Orange

Thanks Hans the pesky $ got me, in my first attempt I put it in the wrong place but all is well now