MaunishP Member Apr 13, 2015 #1 Hi Team, I want to count cells conditional formatting highlighted cells from on another worksheet here ... Please find attached workbook. Regards, Maunish Patel Attachments 04132015.xlsx 04132015.xlsx 33.5 KB · Views: 2
Hi Team, I want to count cells conditional formatting highlighted cells from on another worksheet here ... Please find attached workbook. Regards, Maunish Patel
Luke M Excel Ninja Staff member Apr 13, 2015 #2 Rather than trying to count colors (which XL isn't setup to do), we'll use the same criteria that your conditional formatting is already using to do the counts. Attachments CF counting.xlsx CF counting.xlsx 39.4 KB · Views: 4
Rather than trying to count colors (which XL isn't setup to do), we'll use the same criteria that your conditional formatting is already using to do the counts.
MaunishP Member Apr 13, 2015 #3 Thanks Luke, I initially used same kind of formula if Countif . All credits goes to ninja's like you. I search this formula from forum and tried to apply it. Hats off to all of you Ninja's & members. Regards, Maunish PAtel
Thanks Luke, I initially used same kind of formula if Countif . All credits goes to ninja's like you. I search this formula from forum and tried to apply it. Hats off to all of you Ninja's & members. Regards, Maunish PAtel
.