conditional formatting

[Kevin Carter]

hi
i have a worksheet that contains a lists of employees in column A
in Row 7 i have the dates from 1/1/2013 to 31/12/2013
i am trying to conditionaly format the column so the weekends are coloured grey
i am using the foloowing formula as a conditional format rule but it is colouring every cell in the range

=WEEKDAY($N7,2)>5 format = fill grey

can some please tell me what i am doing wrong

thanks

kevin

 

[GS]

Kevin Carter formulated on Tuesday :

hi
i have a worksheet that contains a lists of employees in column A
in Row 7 i have the dates from 1/1/2013 to 31/12/2013
i am trying to conditionaly format the column so the weekends are coloured
grey i am using the foloowing formula as a conditional format rule but it is
colouring every cell in the range

=WEEKDAY($N7,2)>5 format = fill grey

can some please tell me what i am doing wrong

thanks

kevin

You say your dates are in row 7, but your formula uses column-absolute,
row-relative referencing. Switch the $ symbol between the column label
and 7: =WEEKDAY(N$7,2)>5

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion