condititional formatting!
 

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

condititional formatting!
 

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

Hope that helps.

Brgds,
Gustavo.


"via135" escreveu na mensagem ...

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

condititional formatting!
 

did you search for conditional formatting in the forum archives?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522314

condititional formatting!
 

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 FormatConditional 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" wrote in
message ...

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

condititional formatting!
 

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

condititional formatting!
 

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 FormatConditional 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" wrote
in
message ...

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

condititional formatting!
 

You're welcome!

Biff

"via135" wrote in
message ...

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 FormatConditional 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" wrote
in
message ...

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