How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6131
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

Can the text color in a cell be changed in a if formula?

Customer Question

can the text color in a cell be changed in a if formula?
Submitted: 9 months ago.
Category: Microsoft Office
Expert:  Jess M. replied 9 months ago.

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.

Best regards,
Jess

Customer: replied 9 months ago.
The sample of the Excel file is attached.
Expert:  Jess M. replied 9 months ago.

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.

Best regards,

Jess

Expert:  Jess M. replied 9 months ago.

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:

http://filesxpress.com/d-7399f667

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.

Thank you!

Best regards,
Jess