Conditional Format is date is Sat or Sun
 

Afternoon,

Have a spreadsheet with dates (column A) and then in the column next to that
with the day (column B). Want to change the colour of that row from column A
to O which has the day as Sat and Sun.

Thanks

Conditional Format is date is Sat or Sun
 

Use CF with a formula of

=WEEKDAY(A2,2)5

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sunnyskies" wrote in message
...
Afternoon,

Have a spreadsheet with dates (column A) and then in the column next to
that
with the day (column B). Want to change the colour of that row from column
A
to O which has the day as Sat and Sun.

Thanks