| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format weekend
id like to color saturdays and sundays with different color then my
workdays. Is it possible to do this using conditional format? And how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format weekend
On Sun, 14 Dec 2008 04:32:43 -0800 (PST), Mortir
wrote: id like to color saturdays and sundays with different color then my workdays. Is it possible to do this using conditional format? And how? If A1:A100 is the range where your dates are, try the following as formula within Conditional Formatting: =(WEEKDAY(A1:A100,2)5) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional format weekend
On 14 dec., 13:50, Lars-Åke Aspelin wrote:
On Sun, 14 Dec 2008 04:32:43 -0800 (PST), Mortir wrote: id like to color saturdays and sundays with different color then my workdays. Is it possible to do this using conditional format? And how? If A1:A100 is the range where your dates are, try the following as formula within Conditional Formatting: =(WEEKDAY(A1:A100,2)5) Hope this helps / Lars-Åke great, many tnx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
| Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
| Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
| How do I use conditional formatting to hilite weekend dates where. | Excel Worksheet Functions | |||
| Change the text format for weekend days (Sat, Sun) | Excel Worksheet Functions | |||
Linear Mode
