Can one count cells having a certain format? i.e. using countif?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After using conditional formatting to color certain cells red, can I use a
function such as 'countif' to count the number of cells that have red
formatting? I know I can write my own function to do this, but would prefer
to use a built in function if one is available.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf Condition based on lookup in a list of values 5
countifs Function not giving desired result with date criteria 2
Excel Need Countifs Formula Help 0
CountIf previous cell formula 0
Counting cells with conditional formatting 3
In Excel, how do I count cells with a particular format (e.g. colo 3
using CountIF function or Array? 3
Countifs for multiple worksheets 4

Back
Top