| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight today's date in a monthly schedule spreadsheet.
I'm using Excel for scheduling employees. The spreadsheet is set up for the
entire month with each day's date in column A. How do I create conditional formatting to automatically highlight the row containing "today's" date? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I highlight today's date in a monthly schedule spreadsheet.
Highlight rows
CF Formula is: =$a1=Today() select colour OK "munch" wrote: I'm using Excel for scheduling employees. The spreadsheet is set up for the entire month with each day's date in column A. How do I create conditional formatting to automatically highlight the row containing "today's" date? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I highlight today's date in a monthly schedule spreadsh
Worked perfectly - thank you.
"Toppers" wrote: Highlight rows CF Formula is: =$a1=Today() select colour OK "munch" wrote: I'm using Excel for scheduling employees. The spreadsheet is set up for the entire month with each day's date in column A. How do I create conditional formatting to automatically highlight the row containing "today's" date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I highlight today's date in a monthly schedule spreadsheet. | Excel Discussion (Misc queries) | |||
| monthly work schedule for 2 people on same calendar | Excel Discussion (Misc queries) | |||
| How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
| template for monthly income/expenses corresponding to IRS Schedule | Excel Discussion (Misc queries) | |||
| monthly one shift work schedule | New Users to Excel | |||
Linear Mode
