How To Automatically Highlight Cells That Has Formula Using Conditional Formatting

How To Automatically Highlight Cells That Has Formula in Excel.
How about an automated system that can highlight each cell you have written formula inside it? In this tutorial I’ll explain an excellent way you can use to mark cells that has formula in it. The most important part is that it will automatically highlight cells with formula in the future also. It means you do this one time and until you turn it off it will keep highlighting cells that has formula or functions in it. I’ll be using Conditional Formatting along with the isformula function.
Learn ISFormula Function here:    • How to Use ISFormula Function In Excel  
So, lets follow the steps below to highlight cells with formulas in excel using conditional formatting.
Step 1: Select the entire worksheet
Step 2: Click on Conditional Formatting.
Step 3: Click on New Rule
Step 4: Select “Use formula to determine which cells to format”
Step 5: Write =IsFormula(A1) in the “Format Values where this formula is True” bar.
Step 6: Click Format and select the highlight color.
Step 7: Click ok and done.
Now you’ll see all the cells that has a formula inside it is highlighted. Also, if you write any function or formula inside this worksheet, it will highlight that cell also. This is how you highlight cells in excel based on formula. This is the easiest excel conditional formatting formula to highlight if cell contains formula.
#Highlight #Formula #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial