I have a column of days of the week. (Sat, Sun, Mon, etc.) Is there
any way I can automate changing the cell's color and/or pattern, based
on whether or not the say is 'Sat' or 'Sun'?

Thanks in advance,

Tom

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.
--
Gary''s Student


"Tcs" wrote:

I have a column of days of the week. (Sat, Sun, Mon, etc.) Is there
any way I can automate changing the cell's color and/or pattern, based
on whether or not the say is 'Sat' or 'Sun'?

Thanks in advance,

Tom

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.

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.

Works just great. Thanks so much.

On Sun, 25 Sep 2005 07:46:07 -0700, Vacation's Over
wrote:

Weekday(Serial_number,1)