Conditional Formatting

[ChrisG77]

Hello

I'm having a bit of trouble with conditional formatting in excel, bu
I'm not sure I am going about it the right way.

The first condition I am using is to turn the date red and bold if th
date is over 70 days.

=TODAY()-D6>70

The trouble I am having is getting the date, in D6 to go back to a blac
font, once text is entered in another cell, say G6 for example.

Is it possible to do this with conditional formatting.

Thank you for any help you can provid

 

[Claus Busch]

Hi Chris,

Am Tue, 19 Feb 2013 13:29:51 +0000 schrieb ChrisG77:

The first condition I am using is to turn the date red and bold if the
date is over 70 days.

=TODAY()-D6>70

The trouble I am having is getting the date, in D6 to go back to a black
font, once text is entered in another cell, say G6 for example.

try:
=AND(TODAY()-D6>70,LEN(G6)=0)


Regards
Claus Busch

 

[ChrisG77]

Hi Chris,

Am Tue, 19 Feb 2013 13:29:51 +0000 schrieb ChrisG77:
-

try:
=AND(TODAY()-D6>70,LEN(G6)=0)


Regards
Claus Busch

Hi Claus

Great, that works perfectly. Thank you for your help and quic
response