format a cell using today's date

  • Thread starter Thread starter GREG318
  • Start date Start date
G

GREG318

Hello,
My first post. I have a column of all the days in September, is ther
a way I can use conditonal formationg so that on each day, today's dat
will be highlighted?
Any help is appreciated, thank you
 
Hi, Greg. Welcome to the Forum!!!

Highlight all of the cells you want to apply this condition to. Clic
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 o
Patterns (for fill color)

Click OK and OK again to set this Condition.

Good Luck

Bruc
 
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.
 
GREG318 said:
Thanks for the welcome. I did what you told me Bruce, but What happene
was all the selected cells where changed to that format. I wanted t
know if there is a way that only today's date will get that format, an
then when I open the workbook tomorrow it will just highlight the ne
date. Maybe I didn't do it right. Any suggestions? Thanks.
Click to expand...
You followed my directions. Maybe I didn't give accurate informatio
(oops!).

A slight correction to the formula:

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

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

Does this work now?

Sorry for the mis-information
 
Back
Top