Conditional formating to highlight dates 30, 60, and 90 days out?
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.
|