ExcelBanter - How do I highlight today's date in a monthly schedule spreadsheet.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I highlight today's date in a monthly schedule spreadsheet. (https://www.excelbanter.com/excel-discussion-misc-queries/153450-how-do-i-highlight-todays-date-monthly-schedule-spreadsheet.html)

munch

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?

Toppers

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?

munch

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?

All times are GMT +1. The time now is 04:29 AM.