top of page

How to get Totals Based on Cell Color Creating / UDF (User Defined Functions) with VBA

Some times we requires some Special or Customized Functions in Excel but we may not get them.

For Example if you want get Total Values, in a range of Cells, based on the Color of the Cell or Font Color ,

you may not find any specific formula for it.

However VBA at your rescue. You can create a Quick UDF (User defined Function) to get the result they way you want.

Watch this Video to know how to create UDF for Totals based on Cell Color.

After that you can try your own how to created Totals based on Font Color .

and Let me know whether you were able to do or not.

96 views0 comments

Recent Posts

See All


The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http


bottom of page