Conditional formatting
Pl. share the formula you are using..
Most likely you are not taking care of the year part...
If you current month is 1,2 or 3 and date past is in 10, 11, 12 then current
- past will not be greater than 3.... but for other months it will be as you
expect.
"Amy" wrote:
Hi, i have applied a conditional formatting for the cell to highlight if the
date past 3 months, however it does not work if the months is either on the
10th or 11th month but it works for the rest; 1st to 9th month and 1yr &
above.
Please share your thought in resolving this problem.
Thank you
|