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.