cell color
 

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

cell color
 

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

cell color
 

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.

cell color
 

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.

cell color
 

Works just great. Thanks so much.

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

Weekday(Serial_number,1)