Conditional Formatting Formula needed in order to highlight cells when a date has passed

Hi All

I am stuck trying to work out a formula for my spreadsheet, basically I need the cell to show as Amber if the date in cell I4 is within 3 days of the deadline, providing that cell J4 is blank (shows as no information has been received back) as when the information has been received the cell no longer needs to be highlighted.

Also if the date within I4 has passed and J4 is still blank (as we have still not received the information) I need the row to show as red.

Please help me

excel demo.PNG

Originally Posted by Special-K

Select the range to highlight, I4 to J...whatever row is your last row

Conditional Formatting
New Rule
Use a formula to determine...

=AND(TODAY()>=I4,TODAY()-I4<=3,J4="")
format as Amber

=AND(TODAY()<I4,J4="")
format as Red

Thanks for your help Special K, the formula works, however the cells are still highlighted when I put information into J4.