Conditional Formatting with Function

[Keldar]

Hi

Can anybody help...?

I have a spreadsheet for charting my cashflow and I have listed dates
sequentially down one column but I need to highlight weekends preferably
using conditional formatting. I had previously done it all manually, but
since I realised that this year is a leap-year I have had to shove
everything down a day. I have got the dates in automatically but I want to
change the formatting of the cell if it is a Saturday or Sunday.

I am trying to do something like

OR(weekday(thiscell)=1,weekday(thiscell)=7)

how do I reference thiscell being the cell currently in question?

Once I have done this I want to copy it down the whole column

Any suggestions appreciated

Ian

 

[Roger Govier]

Hi Ian

Mark the whole range of the column concerned, including blan cell to which
you will later add data.
Use Conditional formatting with the formula you presented, remebering to put
an = sign in front of it
and substitute the firstcell address of your chosen range for thiscell
e.g.
=OR(weekday(A2)=1,weekday(A2)=7)

Since this is a reletive reference, it will adjust itself accordingly

 

[Keldar]

ARGGGGH! Of Course...!

Thanks for that I have been spinning in circles all morning with this
one.... More coffee needed I think!

Ian