conditional formatting a date in excel

Hello to all just a small problem i want set a condition in a cell that contains a date , to change to a colour when this date has passed another date by 3 days eg order date received date if the received date has gone over 3 days past the order date i want it to flag up and change colour please could anyone help
Many thanks

Paul

Hi Paul

In this example file the conditional formatting rule:

Please Login or Register  to view this content.

not sure which columns your dates are in, but this method highlights cells where one date exceeds another date by more than 3 days on the same row

if you can't apply this to your file, upload an example of your file and we'll make the necessary adjustments

Thank you so much for your help it worked great thank you

Kind regards