condititional formatting!

[via135]

hi!

i am having days through C1:AG1 (starting from Sun...ending with Tue)
and dates through C2:AG2 (starting from 1..ending with 31)

what is the formula for conditional formatting to display the Saturdays & the corresponding dates
in one format and Sundays & the corresponding dates in another format?!

-via135

[davesexcel]

did you search for conditional formatting in the forum archives?

[Gustavo Strabeli]

Hi!
Please do the following;
Select C1:AG2
Go to Format; Conditional formating
On "Condition 1", select "Formula is"
Paste this formula: =3DOR(C$1=3D"Sun";C$1=3D"Sat")
Then chose the format you want.

Hope that helps.

Brgds,
Gustavo.


"via135" <[email protected]> escreveu =
na mensagem news:[email protected]...

hi!

i am having days through C1:AG1 (starting from Sun...ending with Tue)
and dates through C2:AG2 (starting from 1..ending with 31)

what is the formula for conditional formatting to display the Saturdays
& the corresponding dates=20
in one format and Sundays & the corresponding dates in another
format?!

-via135


--=20
via135
------------------------------------------------------------------------
via135's Profile: =
http://www.excelforum.com/member.php...userid=3D26725
View this thread: =
http://www.excelforum.com/showthread...eadid=3D522314

[Biff]

Hi!

> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)

Are those entries the results of formulas?

If so, you can use something like this:

Select the range C1:AG2
Goto Format>Conditional Formatting
Condition 1
Formula is: =TEXT(C$1,"ddd")="Sat"
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =TEXT(C$1,"ddd")="Sun"
Click the Format button
Select the style(s) desired
OK out

If the entries are not the results of formulas:

Condition 1
Formula is: =C$1="Sat"
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =C$1="Sun"
Click the Format button
Select the style(s) desired

Biff

"via135" <[email protected]> wrote in
message news:[email protected]...
>
> hi!
>
> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)
>
> what is the formula for conditional formatting to display the Saturdays
> & the corresponding dates
> in one format and Sundays & the corresponding dates in another
> format?!
>
> -via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=522314
>

[Gary''s Student]

For the first row (days) use two conditional formats. cells is equal to and
enter:
="Saturday" with some format
the second condition use:
="Sunday" with another format



For the second row (dates) pick C2 and use two conditional formats formula is:
=(C1="Saturday") with the Saturday format
the second condition use:
=(C1="Sunday") with the Sunday format


--
Gary''s Student


"via135" wrote:

>
> hi!
>
> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)
>
> what is the formula for conditional formatting to display the Saturdays
> & the corresponding dates
> in one format and Sundays & the corresponding dates in another
> format?!
>
> -via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=522314
>
>

[Gary''s Student]

For the first row (days) use two conditional formats. cells is equal to and
enter:
="Saturday" with some format
the second condition use:
="Sunday" with another format



For the second row (dates) pick C2 and use two conditional formats formula is:
=(C1="Saturday") with the Saturday format
the second condition use:
=(C1="Sunday") with the Sunday format


--
Gary''s Student


"via135" wrote:

>
> hi!
>
> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)
>
> what is the formula for conditional formatting to display the Saturdays
> & the corresponding dates
> in one format and Sundays & the corresponding dates in another
> format?!
>
> -via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=522314
>
>

[via135]

thks Biff!

your formula works in a nice way!

-via135

Hi!

> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)

Are those entries the results of formulas?

If so, you can use something like this:

Select the range C1:AG2
Goto Format>Conditional Formatting
Condition 1
Formula is: =TEXT(C$1,"ddd")="Sat"
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =TEXT(C$1,"ddd")="Sun"
Click the Format button
Select the style(s) desired
OK out

If the entries are not the results of formulas:

Condition 1
Formula is: =C$1="Sat"
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =C$1="Sun"
Click the Format button
Select the style(s) desired

Biff

"via135" <[email protected]> wrote in
message news:[email protected]...
>
> hi!
>
> i am having days through C1:AG1 (starting from Sun...ending with Tue)
> and dates through C2:AG2 (starting from 1..ending with 31)
>
> what is the formula for conditional formatting to display the Saturdays
> & the corresponding dates
> in one format and Sundays & the corresponding dates in another
> format?!
>
> -via135
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=522314
>

[Biff]

You're welcome!

Biff

"via135" <[email protected]> wrote in
message news:[email protected]...
>
> thks Biff!
>
> your formula works in a nice way!
>
> -via135
>
>
>
>
> Biff Wrote:
>> Hi!
>>
>> > i am having days through C1:AG1 (starting from Sun...ending with
>> Tue)
>> > and dates through C2:AG2 (starting from 1..ending with 31)
>>
>> Are those entries the results of formulas?
>>
>> If so, you can use something like this:
>>
>> Select the range C1:AG2
>> Goto Format>Conditional Formatting
>> Condition 1
>> Formula is: =TEXT(C$1,"ddd")="Sat"
>> Click the Format button
>> Select the style(s) desired
>>
>> Condition 2
>> Formula is: =TEXT(C$1,"ddd")="Sun"
>> Click the Format button
>> Select the style(s) desired
>> OK out
>>
>> If the entries are not the results of formulas:
>>
>> Condition 1
>> Formula is: =C$1="Sat"
>> Click the Format button
>> Select the style(s) desired
>>
>> Condition 2
>> Formula is: =C$1="Sun"
>> Click the Format button
>> Select the style(s) desired
>>
>> Biff
>>
>> "via135" <[email protected]> wrote
>> in
>> message news:[email protected]...
>> >
>> > hi!
>> >
>> > i am having days through C1:AG1 (starting from Sun...ending with
>> Tue)
>> > and dates through C2:AG2 (starting from 1..ending with 31)
>> >
>> > what is the formula for conditional formatting to display the
>> Saturdays
>> > & the corresponding dates
>> > in one format and Sundays & the corresponding dates in another
>> > format?!
>> >
>> > -via135
>> >
>> >
>> > --
>> > via135
>> >
>> ------------------------------------------------------------------------
>> > via135's Profile:
>> > http://www.excelforum.com/member.php...o&userid=26725
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=522314
>> >
>
>
> --
> via135
> ------------------------------------------------------------------------
> via135's Profile:
> http://www.excelforum.com/member.php...o&userid=26725
> View this thread: http://www.excelforum.com/showthread...hreadid=522314
>