•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formatting within a date range
I am building a heat map for missing timecard data by weeks. The weeks missing data are in column C->Z.
Cell C2 is Jan 2nd, D2 is January 9th, etc
I am trying to apply conditional formatting to the data in cells C3-Z3.
But only if the date in row 2 falls within a separate date range in columns A/B.
For example if someone was scheduled to work only in February, cell A3 would be Feb 1st and cell B3 would be Feb 28th.
I want apply conditional formatting for the C->Z data to the right for February but not Jan/March/etc.
Is it possible to do that?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com