title: How to use COUNTIF to count colors of cells under conditional formatting?
body: <p><a href="https://i.stack.imgur.com/zyUSi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zyUSi.png" alt="enter image description here"></a>I am trying to figure out how to structure a countif formula. I have a table of data along with (broadly speaking) two sets of conditional formatting:
  - for the range of column D through K, the data is a drop-down Yes/No list. If any of those items are marked as "No" and the date in column C is within 30 days of today, the entire row turns red. I couldn't figure out how to do to do this in one big rule, so there's one rule for each column between D through K.
  - column L automatically does a time stamp when the row is edited. if any of those dates goes more than 30 days old, the row turns grey.</p>
  
  <p>At the top, I would like to have a row count for red cells and grey cells. How would I do this?</p>