Excel - How to Change Background Color Based on Cell Value - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Can I use conditional formatting to turn cells with a formula in it a different color?
Solved by T. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/04/2018 - 06:00
Hi there!
User 12/04/2018 - 06:00
Excelchat Expert 12/04/2018 - 06:00
I am almost certain you can!
Excelchat Expert 12/04/2018 - 06:01
have you used formula based conditional formatting? ie. change the color of a cell based on a formula?
User 12/04/2018 - 06:01
yes lots
Excelchat Expert 12/04/2018 - 06:01
I figured
Excelchat Expert 12/04/2018 - 06:02
so select the cell(s) that you want to have highlighted if there is a formula in it
Excelchat Expert 12/04/2018 - 06:02
then conditional formatting > use formula to determine format
Excelchat Expert 12/04/2018 - 06:02
and in the formula... try =ISFORMULA(the cell)
Excelchat Expert 12/04/2018 - 06:03
I just tested it on my Excel sheet and it worked! Let me know if you can get it to work on your end
User 12/04/2018 - 06:04
ok what are putting in the () ?
User 12/04/2018 - 06:04
I got it. Thank you.
Excelchat Expert 12/04/2018 - 06:04
=ISFORMULA(the refrence to the cell that you want to check if there is a formula)'
Excelchat Expert 12/04/2018 - 06:04
oh amazing
Excelchat Expert 12/04/2018 - 06:04
my pleasure... feel free to ping us back if you need further assistance!
User 12/04/2018 - 06:05
Thank you again.
Excelchat Expert 12/04/2018 - 06:05
Anytime! Have a great rest of the day ~

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc