First, and probably easier scenario: how do you (or can you) compare a date (TODAY) to a given month to see if it falls within that month, other than by using the pre-formatted 'A Date Occurring' formulas. Because the 'A date occurring' formulas only apply to the value of the specific cell. I want to apply a comparison of the current date to several dates and highlight them all accordingly (similar way of accomplishing what I am doing below with weeks...).
Second, scenario: see attached image. In this case I am trying to format based upon a comparison of a specified value (the TODAY value in the upper left - highlighted bright yellow) to a date. In the formulas the dates make a 'weekly' range by comparing to a +7 value from the start of the given week. I want to format the entire column based upon whether the TODAY is in the past, the current week, or the future as compared to the date at the top of the column. This would create a 'moving' current week highlight that would progress ands TODAY advances. As you can see the formatting seems to work for the cell that contains the date value, but not for the rest of the cells in its column. I don't know why all of the cells beneath the date value are brown...
Second, scenario: see attached image. In this case I am trying to format based upon a comparison of a specified value (the TODAY value in the upper left - highlighted bright yellow) to a date. In the formulas the dates make a 'weekly' range by comparing to a +7 value from the start of the given week. I want to format the entire column based upon whether the TODAY is in the past, the current week, or the future as compared to the date at the top of the column. This would create a 'moving' current week highlight that would progress ands TODAY advances. As you can see the formatting seems to work for the cell that contains the date value, but not for the rest of the cells in its column. I don't know why all of the cells beneath the date value are brown...
