There is no such native formula in XL. (would require a UDF, and if the
formatting comes from a conditional format, it's even more complicated)

Is there some criteria by which a row is highlighted? You could get your
count based on this...
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Vic" wrote:

What is the formula to count how many lines are highlited in yellow?
Thank you.