Hi, Is there a formula that can help me the number of highlighted cells in a row?
P PASSWORD37 Feb 7, 2006 #1 Hi, Is there a formula that can help me the number of highlighted cells in a row?
B Biff Feb 7, 2006 #2 Hi! http://cpearson.com/excel/colors.htm You're better off using the logic behind why the cells are colored to craft a formula. For example, the cells are colored if the values are less than 10. =COUNTIF(A1:J1,"<10") Biff
Hi! http://cpearson.com/excel/colors.htm You're better off using the logic behind why the cells are colored to craft a formula. For example, the cells are colored if the values are less than 10. =COUNTIF(A1:J1,"<10") Biff
