How conditional format line with date of today

D

dewsbury

Hi All,
Greetings from Ireland!

I have an implementation schedule in Excel. It have one task per each
row. Each task/row has an associated DATE in it.

I want the spreadsheet to highlight in Blue todays tasks automatically
(without having to change the sheet daily). I suspect I can do ith
with conditional formatting but can't quite manage it.

Any ideas.
 
A

Alex Delamain

format, conditonal formatting

condition 1:
Cell value is
Equal to
=today()

then set your format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format Fragmentation 2
Date Calculation & Conditional Formatting 3
Conditional Format (Todays Date) 2
Conditional Formating based on start and end dates 1
conditional formatting on date where today is > or = datevalue 3
formula in conditional formatting with dates 3
How do I highlight today's date in a monthly schedule spreadsheet. 2
Conditional Format - Date + 7 2

Top