condititional formatting!

V

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
 
G

Gustavo Strabeli

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

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)
Click to expand...

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
 
G

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
 
Top