View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MelB MelB is offline
external usenet poster
 
Posts: 23
Default formula in conditional formatting with dates

Cell A1 = doc status with the following possible values:
"Due", "Revise", "Sign", "Complete".

Cell A2 contains a date.

I need a formula for conditional formatting that will turn Cell A2 yellow
with blue bold font if A1="Due" or "Sign" AND Cell A2 is within 31 days of
today's date. Todays date is located in cell A3 as =TODAY().

I have used the conditional formatting function alot in very basic ways, but
am somehow just not able to work out this formula.