conditional fomatting

J

Jock W

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
 
B

Bernard Liengme

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?
 
J

Jock W

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

Bernard Liengme

In A2, =IF(ISBLANK(A3,"",TODAY())
Conditional format A1: select A1 set Formula Is =A3=TODAY(), Format to bold
best wishes
 
J

Jock W

Thanks Bernard.
That works to a point, but the date changes in all cells by using the TODAY
or NOW functions.
I would like the dates to remain as they were input and not to be
automatically updated.
Cheers.
 
G

Guest

Hi

You can use Ctrl+; for inputting the date and Ctrl+: for the time instead.
These put in the current date/time and they remain fixed.

Andy.
 
Top