Forum Discussion
Formulas & Conditional Formatting
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 c...
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