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

Let's assume your data start from row 2 (row 1 is for column headers). Select the datarange in column A and activate Conditiona Formatting;

Create a 1st rule. Select "Use a formula to determine which cells to format" (this selection goes for all rules). Enter the formula Click <Format>, activate tab Number, select category Custom, and enter into Type field "information provided". <OK>. <OK>;

Create 2nd rule. Enter the formula Click <Format>, activate tab Font, and select yellow as font color. <OK>. <OK>;

Create 3rd rule. Enter the formula Click <Format>, activate tab Font, and select red as font color. <OK>. <OK>;

Check rules order (from top down: red, yellow, text replaced), and that Stop if True is unchecked for all rules. When different, then make needed changes;

Click <Apply>.

I haven't checked Arvi's solutions but don't forget to eventually change the semi colons to commas depending on your regional settings

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I usually remember to use commas instead (when I write the formula directly into post), but this time I tested formulas, and then copied them into post.

Well, as the OP didn't indicate his/her location....

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This worked a treat. Thanks so much for your help.