conditional fomatting

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.

"Jock W" <JockW@discussions.microsoft.com> wrote in message
news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
> 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

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" <JockW@discussions.microsoft.com> wrote in message
news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
> 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

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" <JockW@discussions.microsoft.com> wrote in message
> news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
> > 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
>
>
>

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" <JockW@discussions.microsoft.com> wrote in message
news:6D6C73C8-9F6E-47E0-9112-C4D3C4EACA71@microsoft.com...
> 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" <JockW@discussions.microsoft.com> wrote in message
>> news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
>> > 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
>>
>>
>>

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 Waddington


"Bernard Liengme" wrote:

> 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" <JockW@discussions.microsoft.com> wrote in message
> news:6D6C73C8-9F6E-47E0-9112-C4D3C4EACA71@microsoft.com...
> > 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" <JockW@discussions.microsoft.com> wrote in message
> >> news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
> >> > 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

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.

"Jock W" <JockW@discussions.microsoft.com> wrote in message
news:9D139D3E-0DE7-4487-8887-D2D558C1EB03@microsoft.com...
> 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 Waddington
>
>
> "Bernard Liengme" wrote:
>
>> 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" <JockW@discussions.microsoft.com> wrote in message
>> news:6D6C73C8-9F6E-47E0-9112-C4D3C4EACA71@microsoft.com...
>> > 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" <JockW@discussions.microsoft.com> wrote in message
>> >> news:22285074-5FFE-4833-957D-3987708A7F0F@microsoft.com...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>