Hi,
before I post the problem that I am facing with I would like to say that I have read most of the threads posted on this and other excel related forums. I was looking for the solutinion of my problem but at the end it looks like I am not good enough to solve this problem on my own.
And the problem is (as attached):
I have two columns. In column B is the date of "last check". I column A is the date of "next check". I would like to have cell A2 in yellow color 334 days after the date entered in cell A3 and than in red color 365 days after the date entered in cell A3. Same thing for cell B2 related to date entered in cell B3. Yellow color in cells announces that check will expire within 30 days and red color that check has been expired.
I hope that I have described it well and would like to thank anyone who can help
Bookmarks