Hi All,
I am stuck trying to workout a formula for my spreadsheet, basically I need the row to show as Amber if the date in cell I4 is within 3 days of the deadline, providing that cell J4 is blank. Also if the date within I4 has passed and J4 is either blank or passed the dated within I4 I need the row to show as red, also if J$ is blank the cell should not highlight.
Hopefully that makes sense
excel demo.PNG
Bookmarks