format a cell using today's 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
 
S

swatsp0p

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
 
G

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.
 
S

swatsp0p

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
 
Top