| 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. |
| 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 | |||
Threaded Mode
