Forum Discussion
LInedora
Aug 20, 2023Copper Contributor
Conditional Formatting
I'm trying to highlight different dates depending on how long ago they were on a sheet. For example Less than 30 days Green, Between 30 and 90 days Blue and greater than 90 Days red. I have tried a l...
HansVogelaar
Aug 20, 2023MVP
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
LInedora
Aug 20, 2023Copper Contributor
https://1drv.ms/x/s!AkNieIxqhd6NgS2YymFDwQp9CcWD?e=mlUIh1 Here I Deleted all sensitive data. Thanks for all your help and Patience
- HansVogelaarAug 20, 2023MVP
See the attached version. I removed green as default color, and created a whole new set of rules.