•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional Formating to highlight different dates on a spreadsheet.
Hi there, I need assistance with creating a formula to highlight dates that are 3 - 6 months hold and dates that are +6months from the date I open the spreadsheet. Example, this spreadsheet was created today, but if I were to open the spreadsheet on 3 weeks, the highlighted dates change according to that days dates if applicable to the rule. The data I'm trying to do this for is A1:J565. Row 1 are column titles if that makes a difference for the rule. The date colum is I. I appreciate any help I can get.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#row zero