Hi Everyone,
I'm trying to color fill in cells based on the date ranges in other cells. For example, A3 has a date of "11/9/2017". B1 reads "11/3/2017," C1 reads "11/10/2017," and D1 reads "11/17/2017." I want C3 to fill based on the fact that 11/3/2017 < 11/9/2017 <= 11/10/2017. Does this make sense? My overall purpose is to create formula that auto fills across an entire sheet based on whether the dates in Column A fall within a week dictated in Row 2. Visual representation of what I'm trying to achieve is attached. Thanks for anyone who can give me some direction here.
Bookmarks