Hi guys
Please see attached the workbook. The result appears in the sheet when the user click on Enter button in the form . Now I also want to add the code that will change the background color where date appears in the cells. If the todays date is 10months after the date in the cell then the back color of that cell should be amber and if the date is 12 months after the cell date then backcolor should be red. So I want to check all cells where date appears and in the code we have to check from column B2 to max columns where data appears and upto usedrange in the sheet.
I hope anyone can help me to write code so that when the user click Enter button in the userform then it should change the back color of the cells depending upon the date calculations.
Thanks
Bookmarks