Forum Discussion
Conditional formatting using date passed and value in another column
Hi please could anyone help with this - I'm trying to use an 'AND' formula but seem to be messing it up I have a sheet tracking projects, showing the date open - the date is in column B, and colu...
jimmybii I believe these rules will achieve what you describe.
Assuming your date starts on row 3. Example file attached.
- Absolutely brilliant - thanks so much, have been trying to crack this for weeks until discovering this forum!
