| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
