software

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
amp; the corresponding dates
in one format and Sundays amp; the corresponding dates in another
format?!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=522314Hi!
Please do the following;
Select C1:AG2
Go to Format; Conditional formating
On quot;Condition 1quot;, select quot;Formula isquot;
Paste this formula: =OR(C$1=quot;Sunquot;;C$1=quot;Satquot;)
Then chose the format you want.

Hope that helps.

Brgds,
Gustavo.quot;via135quot; gt; 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
amp; the corresponding dates
in one format and Sundays amp; the corresponding dates in another
format?!

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=522314
did you search for conditional formatting in the forum archives?--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=522314Hi!

gt; i am having days through C1:AG1 (starting from Sun...ending with Tue)
gt; 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 Formatgt;Conditional Formatting
Condition 1
Formula is: =TEXT(C$1,quot;dddquot;)=quot;Satquot;
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =TEXT(C$1,quot;dddquot;)=quot;Sunquot;
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=quot;Satquot;
Click the Format button
Select the style(s) desired

Condition 2
Formula is: =C$1=quot;Sunquot;
Click the Format button
Select the style(s) desired

Biff

quot;via135quot; gt; wrote in
message ...
gt;
gt; hi!
gt;
gt; i am having days through C1:AG1 (starting from Sun...ending with Tue)
gt; and dates through C2:AG2 (starting from 1..ending with 31)
gt;
gt; what is the formula for conditional formatting to display the Saturdays
gt; amp; the corresponding dates
gt; in one format and Sundays amp; the corresponding dates in another
gt; format?!
gt;
gt; -via135
gt;
gt;
gt; --
gt; via135
gt; ------------------------------------------------------------------------
gt; via135's Profile:
gt; www.excelforum.com/member.php...oamp;userid=26725
gt; View this thread: www.excelforum.com/showthread...hreadid=522314
gt;
For the first row (days) use two conditional formats. cells is equal to and
enter:
=quot;Saturdayquot; with some format
the second condition use:
=quot;Sundayquot; with another format
For the second row (dates) pick C2 and use two conditional formats formula is:
=(C1=quot;Saturdayquot;) with the Saturday format
the second condition use:
=(C1=quot;Sundayquot;) with the Sunday format--
Gary''s Studentquot;via135quot; wrote:

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


thks Biff!

your formula works in a nice way!

-via135

Biff Wrote:
gt; Hi!
gt;
gt; gt; i am having days through C1:AG1 (starting from Sun...ending with
gt; Tue)
gt; gt; and dates through C2:AG2 (starting from 1..ending with 31)
gt;
gt; Are those entries the results of formulas?
gt;
gt; If so, you can use something like this:
gt;
gt; Select the range C1:AG2
gt; Goto Formatgt;Conditional Formatting
gt; Condition 1
gt; Formula is: =TEXT(C$1,quot;dddquot;)=quot;Satquot;
gt; Click the Format button
gt; Select the style(s) desired
gt;
gt; Condition 2
gt; Formula is: =TEXT(C$1,quot;dddquot;)=quot;Sunquot;
gt; Click the Format button
gt; Select the style(s) desired
gt; OK out
gt;
gt; If the entries are not the results of formulas:
gt;
gt; Condition 1
gt; Formula is: =C$1=quot;Satquot;
gt; Click the Format button
gt; Select the style(s) desired
gt;
gt; Condition 2
gt; Formula is: =C$1=quot;Sunquot;
gt; Click the Format button
gt; Select the style(s) desired
gt;
gt; Biff
gt;
gt; quot;via135quot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt; hi!
gt; gt;
gt; gt; i am having days through C1:AG1 (starting from Sun...ending with
gt; Tue)
gt; gt; and dates through C2:AG2 (starting from 1..ending with 31)
gt; gt;
gt; gt; what is the formula for conditional formatting to display the
gt; Saturdays
gt; gt; amp; the corresponding dates
gt; gt; in one format and Sundays amp; the corresponding dates in another
gt; gt; format?!
gt; gt;
gt; gt; -via135
gt; gt;
gt; gt;
gt; gt; --
gt; gt; via135
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; via135's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=26725
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=522314
gt; gt;--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=522314You're welcome!

Biff

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