MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF (?) Interior Color

Posted by Melissa B on January 29, 2002 1:40 PM

Is there a way to Count cells that are a certain color? I.e., I have a spreadsheet with cells that are yellow, and cells that are magenta. How can I get a count of all the magenta cells?

Posted by Tom Urtis on January 29, 2002 1:51 PM

See Juan Pablo's UDF at 14070.html