Counting the cells which have yellow as background

[Sayan2795]

Hi,
I have a statement where conditional formatting has been done to mark the cells which do not fall under the condition with yellow color. So the table is like this

Characteristics date1 date2 date3 date4
A1. Val1. Val2. Val3. Val4
A2. Val1. Val2. Val3. Val4

Now some values under the date fall under the conditional formatting criteria.
The thing I have to do is put a column after the last column which counts the number of cells in a row with a background color as yellow.
The main problem is , the data in the cell is extracted from a macro hence the number of columns keep changing. But the number of rows is same i.e 258. So to add a column which counts the number of yellow cells in a row we first need to find the last column and then add a new column after that to put the values or count of yellow cells.
Please help
Thank you

 

[Aladin Akyurek]

What is the formula that is used for the conditional formatting?

 

[Sayan2795]

@Aladin Akyurek
Thank you For you response. The formula is very complicated and takes in values from multiple sheet. It won't be easy to explain here . That's why I need to count based on cell colors. Can you help ??

Thank you

 

[Aladin Akyurek]

@Aladin Akyurek
Thank you For you response. The formula is very complicated and takes in values from multiple sheet. It won't be easy to explain here . That's why I need to count based on cell colors. Can you help ??

Thank you

I was asking for the formula that you use in conditional formatting. That formula or the information it provides can be used to obtain the desired count. Otherwise you need vba the other helpers might want to provide.