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
hello
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.
