LinkBack URL
About LinkBacks
Looking for a formula that will count cells that match a given background color and number criteria.
Looking for a formula that will count cells that match a given background color and number criteria.
I do not know of any built in FORMULA but can be done by a macro or function
study this
http://www.cpearson.com/excel/colors.htm
I am not an expert. better solutions may be available
$$$$venkat1926$$$$@gmail.com
Hi jmk345,
Welcome to the forum.
Provide more details on number criteria, if possible attach a sample file. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Try this for desired color and minimum value you want to check
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks