Conditional format to change row colour

J

Jenny P

I've looked at quite a few posts but can't seem to get this to work.

I have a spreadsheet with information about delivery dates and within forty
eight hours of the delivery date I have to provide information.

I need the row colour to change according to the date that is entered in
column J, if the current date is one day after the entered delivery date I
need the row to turn yellow. If the current day is two days after the
delivery date I need the row to turn orange and red if it's three days.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top