software

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

Hi

Set the CF of A1 to
=A2=TODAY()
using the Formula Is option.

Andy.

quot;Jock Wquot; gt; wrote in message
...
gt; If cell A2 contains todays date (using the NOW() formula) how do I get the
gt; contents of A1 to be displayed either in bold and/or different colour?
gt;
gt; tia
gt;
gt; --
gt; Jock Waddington
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

quot;Jock Wquot; gt; wrote in message
...
gt; If cell A2 contains todays date (using the NOW() formula) how do I get the
gt; contents of A1 to be displayed either in bold and/or different colour?
gt;
gt; tia
gt;
gt; --
gt; Jock Waddington
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 Waddingtonquot;Bernard Liengmequot; wrote:

gt; Would you like to rephrase. A2 will always displays today's date if it has
gt; =NOW() unless you have not calculated the worksheet. If you have not
gt; calculated it, then how do we now the date - a catch 22 situation.
gt;
gt; Maybe you want A1 to be somehow formatted if ITS value is today.
gt; With A1 selected open the Conditional Formatting dialog and set it to
gt; Formula Is; =A1=TODAY()
gt; Click Format button and set a format.
gt;
gt; Any help?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Jock Wquot; gt; wrote in message
gt; ...
gt; gt; If cell A2 contains todays date (using the NOW() formula) how do I get the
gt; gt; contents of A1 to be displayed either in bold and/or different colour?
gt; gt;
gt; gt; tia
gt; gt;
gt; gt; --
gt; gt; Jock Waddington
gt;
gt;
gt;

In A2, =IF(ISBLANK(A3,quot;quot;,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 emailquot;Jock Wquot; gt; wrote in message
...
gt; Good point.
gt; What I'm trying to achieve is when text is entered in A3, todays date
gt; automatically appears in A2 and the text in A1 is bold.
gt;
gt; Thanks guys.
gt; --
gt; Jock Waddington
gt;
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Would you like to rephrase. A2 will always displays today's date if it
gt;gt; has
gt;gt; =NOW() unless you have not calculated the worksheet. If you have not
gt;gt; calculated it, then how do we now the date - a catch 22 situation.
gt;gt;
gt;gt; Maybe you want A1 to be somehow formatted if ITS value is today.
gt;gt; With A1 selected open the Conditional Formatting dialog and set it to
gt;gt; Formula Is; =A1=TODAY()
gt;gt; Click Format button and set a format.
gt;gt;
gt;gt; Any help?
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Jock Wquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; If cell A2 contains todays date (using the NOW() formula) how do I get
gt;gt; gt; the
gt;gt; gt; contents of A1 to be displayed either in bold and/or different colour?
gt;gt; gt;
gt;gt; gt; tia
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Jock Waddington
gt;gt;
gt;gt;
gt;gt;
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.
--
Jock Waddingtonquot;Bernard Liengmequot; wrote:

gt; In A2, =IF(ISBLANK(A3,quot;quot;,TODAY())
gt; Conditional format A1: select A1 set Formula Is =A3=TODAY(), Format to bold
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt;
gt; quot;Jock Wquot; gt; wrote in message
gt; ...
gt; gt; Good point.
gt; gt; What I'm trying to achieve is when text is entered in A3, todays date
gt; gt; automatically appears in A2 and the text in A1 is bold.
gt; gt;
gt; gt; Thanks guys.
gt; gt; --
gt; gt; Jock Waddington
gt; gt;
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; Would you like to rephrase. A2 will always displays today's date if it
gt; gt;gt; has
gt; gt;gt; =NOW() unless you have not calculated the worksheet. If you have not
gt; gt;gt; calculated it, then how do we now the date - a catch 22 situation.
gt; gt;gt;
gt; gt;gt; Maybe you want A1 to be somehow formatted if ITS value is today.
gt; gt;gt; With A1 selected open the Conditional Formatting dialog and set it to
gt; gt;gt; Formula Is; =A1=TODAY()
gt; gt;gt; Click Format button and set a format.
gt; gt;gt;
gt; gt;gt; Any help?
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;Jock Wquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; If cell A2 contains todays date (using the NOW() formula) how do I get
gt; gt;gt; gt; the
gt; gt;gt; gt; contents of A1 to be displayed either in bold and/or different colour?
gt; gt;gt; gt;
gt; gt;gt; gt; tia
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; Jock Waddington
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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.

quot;Jock Wquot; gt; wrote in message
...
gt; Thanks Bernard.
gt; That works to a point, but the date changes in all cells by using the
gt; TODAY
gt; or NOW functions.
gt; I would like the dates to remain as they were input and not to be
gt; automatically updated.
gt; Cheers.
gt; --
gt; Jock Waddington
gt;
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; In A2, =IF(ISBLANK(A3,quot;quot;,TODAY())
gt;gt; Conditional format A1: select A1 set Formula Is =A3=TODAY(), Format to
gt;gt; bold
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt;
gt;gt; quot;Jock Wquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Good point.
gt;gt; gt; What I'm trying to achieve is when text is entered in A3, todays date
gt;gt; gt; automatically appears in A2 and the text in A1 is bold.
gt;gt; gt;
gt;gt; gt; Thanks guys.
gt;gt; gt; --
gt;gt; gt; Jock Waddington
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Would you like to rephrase. A2 will always displays today's date if it
gt;gt; gt;gt; has
gt;gt; gt;gt; =NOW() unless you have not calculated the worksheet. If you have not
gt;gt; gt;gt; calculated it, then how do we now the date - a catch 22 situation.
gt;gt; gt;gt;
gt;gt; gt;gt; Maybe you want A1 to be somehow formatted if ITS value is today.
gt;gt; gt;gt; With A1 selected open the Conditional Formatting dialog and set it to
gt;gt; gt;gt; Formula Is; =A1=TODAY()
gt;gt; gt;gt; Click Format button and set a format.
gt;gt; gt;gt;
gt;gt; gt;gt; Any help?
gt;gt; gt;gt; --
gt;gt; gt;gt; Bernard V Liengme
gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt;gt; gt;gt; remove caps from email
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Jock Wquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; If cell A2 contains todays date (using the NOW() formula) how do I
gt;gt; gt;gt; gt; get
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; contents of A1 to be displayed either in bold and/or different
gt;gt; gt;gt; gt; colour?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; tia
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt; Jock Waddington
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
I've conceded to entering the date manually, so that will help.

Thanks Andy

--
Jock Waddingtonquot;Andyquot; wrote:

gt; Hi
gt;
gt; You can use Ctrl ; for inputting the date and Ctrl : for the time instead.
gt; These put in the current date/time and they remain fixed.
gt;
gt; Andy.
gt;
gt; quot;Jock Wquot; gt; wrote in message
gt; ...
gt; gt; Thanks Bernard.
gt; gt; That works to a point, but the date changes in all cells by using the
gt; gt; TODAY
gt; gt; or NOW functions.
gt; gt; I would like the dates to remain as they were input and not to be
gt; gt; automatically updated.
gt; gt; Cheers.
gt; gt; --
gt; gt; Jock Waddington
gt; gt;
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; In A2, =IF(ISBLANK(A3,quot;quot;,TODAY())
gt; gt;gt; Conditional format A1: select A1 set Formula Is =A3=TODAY(), Format to
gt; gt;gt; bold
gt; gt;gt; best wishes
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Jock Wquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Good point.
gt; gt;gt; gt; What I'm trying to achieve is when text is entered in A3, todays date
gt; gt;gt; gt; automatically appears in A2 and the text in A1 is bold.
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks guys.
gt; gt;gt; gt; --
gt; gt;gt; gt; Jock Waddington
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Would you like to rephrase. A2 will always displays today's date if it
gt; gt;gt; gt;gt; has
gt; gt;gt; gt;gt; =NOW() unless you have not calculated the worksheet. If you have not
gt; gt;gt; gt;gt; calculated it, then how do we now the date - a catch 22 situation.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Maybe you want A1 to be somehow formatted if ITS value is today.
gt; gt;gt; gt;gt; With A1 selected open the Conditional Formatting dialog and set it to
gt; gt;gt; gt;gt; Formula Is; =A1=TODAY()
gt; gt;gt; gt;gt; Click Format button and set a format.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Any help?
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Bernard V Liengme
gt; gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; gt;gt; remove caps from email
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Jock Wquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; If cell A2 contains todays date (using the NOW() formula) how do I
gt; gt;gt; gt;gt; gt; get
gt; gt;gt; gt;gt; gt; the
gt; gt;gt; gt;gt; gt; contents of A1 to be displayed either in bold and/or different
gt; gt;gt; gt;gt; gt; colour?
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; tia
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt; Jock Waddington
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;