HI I'm new to this forum so let me start by saying "Forgive Me" if I confuse you.
Here's the problem:
I need to know if there is a way to format a cell that will subtract X#days(say in increments of 30 or more)from current date. Example- if A1 has todays date and B1 has 10-sep-02 and B2 has 1-aug-02 I need a format formula/cell value that will allow an auto color change when the B1(yellow) or B2(red) date is over the limit of days.
Thank you for your help! (in advance of course :wink: )
Here's the problem:
I need to know if there is a way to format a cell that will subtract X#days(say in increments of 30 or more)from current date. Example- if A1 has todays date and B1 has 10-sep-02 and B2 has 1-aug-02 I need a format formula/cell value that will allow an auto color change when the B1(yellow) or B2(red) date is over the limit of days.
Thank you for your help! (in advance of course :wink: )