Formulas & Conditional Formatting

[Rickc407]

Hi,  I have  a spreadsheet that has about 300 rows. I have conditional formatting set to highlight all of the cells that are blank.  I the want the last cell in each row (say j2) to return how many cells in row 2 are highlighted.  So if out of 7 cells in the range A2-i2 there are 3 of them highlighted then I want J2 to return 3.  I will then copy that down to all 300 rows so each row gives me a total of highlighted cells in that row.  

Any ideas?  

Thanks

[#2]

@Rickc407 ,

Perhaps I misunderstood something, but I see no link between conditional formatting and counting of blank cells.

Let say you have conditional formatting rule with the formula =ISBLANK(A2) applied to your range $A$2:$I$300 - it highlights all blank cells.

To count the for each row you may use =COUNTBLANK(A2:I2), when select this column from J2 till J300 and Ctrl+D