I have a column of dates (column A) which i have conditional formatted to turn red if within 5 days from now, yellow if within 10 days & normal if over 10 days from now. The dates are for information to be submitted to me so I can easily see which rows are approaching the deadline. Once information is provided I then want another column (B), in which I plan to put a ‘Y’ when the information is received. When I put this ‘Y’ in, I would like column A to change from a date to say ‘information provided’. Is this possible? Thanks