Ok below mention question in different situation like I want to count the cell color with the cell content which is some tag number(eg:- 120-ps-010,120-ps-13,. So on , so here I can't use the condition function because there are a lot of tag , please guide any of us how to solve this issue

What version of Excel are you using? Did you try pressing F1 in Excel and searching for COUNT COLOR?