format a cell using today's date

[GREG318]

Hello,
My first post. I have a column of all the days in September, is there a way I can use conditonal formationg so that on each day, today's date will be highlighted?
Any help is appreciated, thank you.

[swatsp0p]

Hi, Greg. Welcome to the Forum!!!

Highlight all of the cells you want to apply this condition to. Click Format>Conditional Formatting.
for Condition 1 choose "Formula Is" from the drop down.

enter "=today()" in the formula box (no quotes).

click Format and choose the desired formatting options: Font, Border or Patterns (for fill color)

Click OK and OK again to set this Condition.

Good Luck

Bruce

[GREG318]

Thanks for the welcome. I did what you told me Bruce, but What happened was all the selected cells where changed to that format. I wanted to know if there is a way that only today's date will get that format, and then when I open the workbook tomorrow it will just highlight the new date. Maybe I didn't do it right. Any suggestions? Thanks.

[swatsp0p]

Thanks for the welcome. I did what you told me Bruce, but What happened was all the selected cells where changed to that format. I wanted to know if there is a way that only today's date will get that format, and then when I open the workbook tomorrow it will just highlight the new date. Maybe I didn't do it right. Any suggestions? Thanks.

You followed my directions. Maybe I didn't give accurate information (oops!).

A slight correction to the formula:

Assuming your dates are in A1:A30, highlight this range, click formatting>CF

Cond1: Formula Is: =A1=Today() (note the A1 is a relative reference--no '$') set formatting and OK back out.

Does this work now?

Sorry for the mis-information.