How would this be handled across multiple columns? I have a sheet that needs
this on every other column across more than 20 columns.

~Jen

"Bob Phillips" wrote:


Select column A
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =AND(A1<"",A1<TODAY()+30)
Click the Format button
Select the Pattern Tab
Select red
OK
OK

Second condition

Click Add
Change Condition 2 to Formula Is
Add a formula of =AND(A1<"",A1<TODAY()+60)
Click the Format button
Select the Pattern Tab
Select an amber
OK
OK

Third condition

Click Add
Change Condition 2 to Formula Is
Add a formula of =AND(A1<"",A1<TODAY()+90)
Click the Format button
Select the Pattern Tab
Select an green
OK
OK


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Splatme" wrote in message
...
What would the formula look like to highlight cells, by date (month and
year), as the date approaches? ie... 90, 60 or 30 days out.