| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condition Format a Day that resulted from a formula
Morning,
I have a date in column B3 formated as 15-Feb-2007. Now in column C3 I have copied this date - =B3 and changed the format to 'ddd' resulting in Thu. Now coping cells B3 and C3 down I would like the row to change colour if the date/day becomes a Saturday (Sat) and Sunday (Sun). It should be simple but the weekend mindset has set in. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| preserving format in a formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
