Conditional Format is date is Sat or Sun

S

Sunnyskies

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
 
B

Bob Phillips

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)
 
Top