Excel has a function for that
Weekday(Serial_number,1) depending on international setting in US Sunday is 1
= weekday(date) provides an integer from 1 to 7 you can set your conditions
on this


"Tcs" wrote:

Thanks. But I'm having a problem with it. The formula in my cell,
let's say F21, is "=A21". A21 is where my date is, but F21 is
fomratted to give me the day of week. I can't get the conditional
formatting to work unless I just replace the "=A21" with "Sat" or
"Sun". I even tried setting the date to the date I want. And tht
didn't work either. (I'm *trying* to set up my worksheet so that when
I copy it for a new year, I only have to change ONE date, in ONE
place, in column "A", and the rest of the spreadsheet automatically
adjusts. But it appears I can't get both this *and* the formatting.
At the same time. :) )

Am I doing something wrong? Not doing something that I should?

Thanks,

Tom

On Sat, 24 Sep 2005 18:19:01 -0700, Gary''s Student
wrote:

Yes
Use Conditional Formatting
select the cell(s) then pull-down Format Conditional Formatting...
and then set the value and format. Note you can have multiple conditions.