Given the "red cells" simply equate to count of Today I would suggest you run a COUNTIF (of Date / Today() pending which route you take) via the Open Event against whichever ranges are of interest.