Date formulas

  • Thread starter Thread starter Rusty
  • Start date Start date
R

Rusty

I'm trying to conditional format some cells. I want to change the color of
the font after a certain amount of days. The cell is a date I need it to
change after it is >4 but <6 and to change again when it >6. If someone
could helpit would I would be greatfull.
Thank you,
Rusty
 
something like this
format>conditional format>condition 1>formula is>=a4>a2+6
format>conditional format>condition 2>formula is>=a4>a2+4
 
Back
Top