cell color

[Tcs]

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

[Gary''s Student]

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
>

[Tcs]

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
<[email protected]> 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.

[Vacation's Over]

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
> <[email protected]> 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.
>

[Tcs]

Works just great. Thanks so much.

On Sun, 25 Sep 2005 07:46:07 -0700, Vacation's Over
<[email protected]> wrote:

>Weekday(Serial_number,1)