Conditional Formatting with Function

  • Thread starter Thread starter Keldar
  • Start date Start date
K

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
 
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
 
ARGGGGH! Of Course...!

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

Ian
 
Back
Top