Row wise color coded cells count

Hi All,

I am facing with a unknown knowledge of checking the

checking the Color count of the Rows in Excel
Book1.xlsx

I have mentioned a sample data in the attachment. Know I have to check like row wise

how to get the row wise checking Yellow color and other colors count in Excel and not column wise.

Can anybody tell me of how to do this?

Hi Thank you For your Reply

Here in my Excel I have some data

I have already attached the Excel sheet sample with the name Book1.xlsx

I like to get the count of numbers cells with contains different background colors.

for example
Outputput Expecting
col1 col2 col3 col4 col5 col6 totalRed totalYellow Totblue totpurple

Red yellow red Yellow Blue Purple -- Row1 2 2 1 1

yellow red white purple blue blue---- Row 2


if suppose the data is in this format how can I get the count of red color, Yellow, blue in Row 1 and so no rows

Is it possible to get the total count using Excel .

Please tell me as it is very urgent for me.