Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format using dddd
I am trying to conditionaly format a cell that has been custom formated to
change the date to the day of the week. Ex, 30 Apr 06 changes to Sunday. This is the setup. 1 A G H 2 11 Jun 06 (date I input) =A2-42(30 Apr 06) =G2(fomated dddd = Sunday What I would like help with is when H2=Saturday or Sunday I would like the background to change colors. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format using dddd
Change your formula in G2 to
=TEXT(A2,"DDDD") Then use conditional formatting if cell value is equal to Sunday and apply a colour "mathew" wrote: I am trying to conditionaly format a cell that has been custom formated to change the date to the day of the week. Ex, 30 Apr 06 changes to Sunday. This is the setup. 1 A G H 2 11 Jun 06 (date I input) =A2-42(30 Apr 06) =G2(fomated dddd = Sunday What I would like help with is when H2=Saturday or Sunday I would like the background to change colors. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format using dddd
Sorry I missed the second part of your post. Click add and add a second
conditional format but this time for Saturday. "mathew" wrote: I am trying to conditionaly format a cell that has been custom formated to change the date to the day of the week. Ex, 30 Apr 06 changes to Sunday. This is the setup. 1 A G H 2 11 Jun 06 (date I input) =A2-42(30 Apr 06) =G2(fomated dddd = Sunday What I would like help with is when H2=Saturday or Sunday I would like the background to change colors. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format using dddd
Mike,
That works perfect! Thank you. "Mike" wrote: Sorry I missed the second part of your post. Click add and add a second conditional format but this time for Saturday. "mathew" wrote: I am trying to conditionaly format a cell that has been custom formated to change the date to the day of the week. Ex, 30 Apr 06 changes to Sunday. This is the setup. 1 A G H 2 11 Jun 06 (date I input) =A2-42(30 Apr 06) =G2(fomated dddd = Sunday What I would like help with is when H2=Saturday or Sunday I would like the background to change colors. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions |