Conditional formatting & dates - red, amber

[IsItPossibleToDoThis]

Hi,

Can someone help me please 🙏

I have a spreadsheet and it has column i: X date
I have column J: X due

I already have a formula (=i4+42) in column J and a cell at the top that has =today() in it to add the due date in.

I want column J to turn amber if the due date is in 7 days, stay amber, until the day after, when it turns red as it is overdue.

I can get J to turn r if overdue but I can't make it do the amber bit and all the instructions I'm getting aren't working.

Thank you!

Hi @IsItPossibleToDoThis - did you get this sorted? If you want to PM me with a few more specifics, I'll try to help. If you do PM me, can you be clear when you mean column and when you mean cell and also expand on the formulae you already have entered. Once it's a bit clearer, I'm happy to bounce a few ideas back and forth.

@weathervane1 No I didn't, not in excel, I've left it for now becuase I'm hoping to move the spreadsheet to google sheets, where I did manage to do it.

Thank you, I'll let you know if I do need help in excel though.

No problems OP. Just a thought though - in future if you wanted to add functionality, would it have been better to stay in Excel or will Google do what you need? In my view, Excel is so powerful but sometimes it takes a bit of navigating to do what you need. Good luck anyway 😀