•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
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#row zero
#Excel alternatives
#conditional formatting
#date range
#heat map
#timecard data