Conditional Formatting Help

[davidzahr]

Hi all,

Have a data sheet containing clients and the dates these clients contacted the company. From the column listing dates the clients were established, I'm trying to get any of these dates that are 7 days or older to highlight in red..brain sore and just have not been able to figure it out Any help would be highly appreciated - cheers.

 

[bbott]

Welcome to the board.

Let's say your date is in cell A1. Enter this as the conditional formatting formula:

=A1 < TODAY()-7

Select the red fill. Copy down.

 

[sathi0083]

Hi

I have about 20 drop downs in my excel 2003, I want to apply conditional formatting as below can you please help !!

1. Highlight the cells to GREEN if the value of the cell is from drop down
2. Everything else which is not in drop down format cell as RED

 

[davidzahr]

Hey bbott, thanks mate, glad I found this forum/site!

Formula works, thank you very much. Only issue is that when I apply this conditional formatting to the entire column, cells that have not yet had a date inputted (i.e. are blank) are highlight in red..is there a way to void this?

Much appreciated!
Thx

 

[bbott]

Sure. Delete the other rule and use this formula instead:

=AND(A1 < TODAY()-7,A1 <> "")

 

[davidzahr]

Sure. Delete the other rule and use this formula instead:

=AND(A1 < TODAY()-7,A1 <> "")

bbott, you rock mate, cheers! Worked perfectly!

 

[bbott]

You're welcome, glad it works!