ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Conditional Formatting (https://www.excelbanter.com/new-users-excel/448213-conditional-formatting.html)

ChrisG77

Conditional Formatting
 
Hello

I'm having a bit of trouble with conditional formatting in excel, but 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 the date is over 70 days.

=TODAY()-D670

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.

Is it possible to do this with conditional formatting.

Thank you for any help you can provide

Claus Busch

Conditional Formatting
 
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()-D670

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()-D670,LEN(G6)=0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

ChrisG77

Quote:

Originally Posted by Claus Busch (Post 1609502)
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()-D670

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()-D670,LEN(G6)=0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2



Hi Claus

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


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com