Apr 18 2019 02:30 PM
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
Apr 18 2019 02:41 PM
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