Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
Can you please send me a sample of your Excel file with your sample data so that I can work on it and send back to you? Just remove sensitive information.
You can attach the sample Excel file when you reply using the paper clip icon.Please let me know by replying to me here so that I can help you further.
Thank you for the sample file. Please allow me to work on this and I will get back to you after building a solution for this.
Hi, thank you for your patience.
In order to solve this problem you will need to use Conditional Formatting. However, you need to have a location of the dynamic date -- that is, a specific cell that you can hide somewhere that will hold today's date. In this sample I used cell E2.
Then use conditional formatting to change the text color if the cells are less than or equal to E2.
Here is the completed file:
I hope that helped.Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.