| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Weekends
Is it possible to apply a conditional format to weekend dates? For example,
my spreadsheet has been filled in with the date format showing the days "Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a conditional format, but I cannot seem to get it working. -- Thanks for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Weekends
Use this for A1 and paint it in for other cells that have dates you want this
format for Conditional formatting - formula is =WEEKDAY(A1,2)5 select a colour Mike "TamIam" wrote: Is it possible to apply a conditional format to weekend dates? For example, my spreadsheet has been filled in with the date format showing the days "Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a conditional format, but I cannot seem to get it working. -- Thanks for your help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting Weekends
Wonderful!! Many thanks Mike!
-- Thanks for your help! "Mike" wrote: Use this for A1 and paint it in for other cells that have dates you want this format for Conditional formatting - formula is =WEEKDAY(A1,2)5 select a colour Mike "TamIam" wrote: Is it possible to apply a conditional format to weekend dates? For example, my spreadsheet has been filled in with the date format showing the days "Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a conditional format, but I cannot seem to get it working. -- Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting help | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Hybrid Mode
