In A2, =IF(ISBLANK(A3,"",TODAY())
Conditional format A1: select A1 set Formula Is =A3=TODAY(), Format to bold
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Jock W" wrote in message
...
Good point.
What I'm trying to achieve is when text is entered in A3, todays date
automatically appears in A2 and the text in A1 is bold.

Thanks guys.
--
Jock Waddington


"Bernard Liengme" wrote:

Would you like to rephrase. A2 will always displays today's date if it
has
=NOW() unless you have not calculated the worksheet. If you have not
calculated it, then how do we now the date - a catch 22 situation.

Maybe you want A1 to be somehow formatted if ITS value is today.
With A1 selected open the Conditional Formatting dialog and set it to
Formula Is; =A1=TODAY()
Click Format button and set a format.

Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jock W" wrote in message
...
If cell A2 contains todays date (using the NOW() formula) how do I get
the
contents of A1 to be displayed either in bold and/or different colour?

tia

--
Jock Waddington