Forum Discussion
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...
Right I just tried that and now The Dates are green but everything else is Red. The Dates don't color themselves properly when I change them
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?
- https://1drv.ms/x/s!AkNieIxqhd6NgS2YymFDwQp9CcWD?e=mlUIh1 Here I Deleted all sensitive data. Thanks for all your help and Patience
See the attached version. I removed green as default color, and created a whole new set of rules.