In this article we will learn how to format the cells which is containing the formulas in Microsoft Excel.
To format the cells which contain formulas, we use the Conditional Formatting feature along with the ISFORMULA function in Microsoft Excel.
Conditional Formatting: -Conditional Formatting is used to highlight the important points with color in a report based on certain conditions.
ISFORMULA-This function is used to check whether a cell reference contains a formula and it returns a True or False.
We need to check whether cell E3 containsa formula or not.
To check, follow the below given steps:-
Let’s take an example to understand how we can highlight the cells which contain formulas.
We have data in range C2:G7, in which column C contains Agents name, column D contains No. of sales, column E contains sales amount and column F contains Average sales amount. We need to highlight the cells which contain the formula.
Follow the below given steps:-
All cells which contain formulas will get highlighted with the chosen color. This is the way we can highlight the cells containing formulas in an Excel sheet by using the Conditional Formatting option along with the ISFORMULA function.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.