Ok guys now I got something that may be a little more complicated but may not be. So for my loans we have them by stages from 0 to 5. When loans are in stage 2 for more than 15 days i need excel to mark. Stating I have the stage where the loan is in cell I2, is there a way that I can have another cell let say O2 to put the date that cell went to 2? so that way I can have another cell that would substract todays date minus that date and create a rule than when the loan is =>15 it marks it red. Thanks for any help guys.