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
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting
- Thread starter SarahH7
- Start date
-
- Tags
- column days information put
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,659
- Office Version
- 365
- Platform
- Windows
Hi & welcome to MrExcel
You can (sort of) do that with CF.
New Rule > Use formula > =$B1="Y" > Format > Number > Custom > "Information Provided" (including quotes) > OK > Ok
Then manage Rules > Make sure that the new rue is above the existing rule > Check "Stop if True"
This will not change the data in col A but will display Information Provided.
You can (sort of) do that with CF.
New Rule > Use formula > =$B1="Y" > Format > Number > Custom > "Information Provided" (including quotes) > OK > Ok
Then manage Rules > Make sure that the new rue is above the existing rule > Check "Stop if True"
This will not change the data in col A but will display Information Provided.
Last edited:
Upvote
0
