1 min readfrom 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?

submitted by /u/Anneisabitch
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com