Custom or conditional format to highlight today's date?

  • Thread starter Thread starter Tonso
  • Start date Start date
T

Tonso

Using Excel 2002, I have all 365 days of the year listed in column B,
formatted as "03/14/01". When i open the workbook, I would like the
current date to be bold and red. Can I do this with a conditional
format?
I have tried =Today with no success.

Thanks

Tonso
 
Tonso said:
Using Excel 2002, I have all 365 days of the year listed in column B,
formatted as "03/14/01". When i open the workbook, I would like the
current date to be bold and red. Can I do this with a conditional
format?
I have tried =Today with no success.

Thanks

Tonso
Click to expand...

As a purely amateur user of excel - I only managed to do this by making
a1=Now() and then conditional formatting the dated cells as: Cell Value Is |
Equal to | =A1, I had to delete the quote marks that conditional formatting
put in - I stress I'm only an amateur!

I look forward to a professional solution.

Peter
 
As a purely amateur user of excel - I only managed to do this by making
a1=Now() and then conditional formatting the dated cells as: Cell ValueIs |
Equal to | =A1, I had to delete the quote marks that conditional formatting
put in - I stress I'm only an amateur!

I look forward to a professional solution.

Peter
Click to expand...

Peter,

That works with the Today function for me, and is a good solution.
Thanks!! I am still wondering why my condtional format formula,
=Today , did not work.
 
Peter,

That works with the Today function for me, and is a good solution.
Thanks!!  I am still wondering why my condtional format formula,
=Today  , did not work.- Hide quoted text -

- Show quoted text -
Click to expand...

I found out why my =Today conditionla format formula di dnot work. It
should have been =Today(). Even though no arguments are required. I
should have known better.

Thanks again,

Tonso
 
in 2003 conditional formatting on column works with "cell value is" "equal
to" =today()

Eric
 
Back
Top