View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKD KKD is offline
external usenet poster
 
Posts: 31
Default Any (6) consecutive entries

I have a table that shows number of hours worked each month in columns (a
single row for each employee). I want my table to alert me when the sum of
any six consecutive months equals 400.

I wanted to use conditional formatting, but can't figure out how to write
the formula to look at the sum of "any six consecutive entries"

-
KKD