Change The Colour Of Text In A Row Depending On The Date Entered

Hey all, first time poster here!

I'm working on a project for work, which includes entering in expiry dates for certain pieces of information relating to work sites. I'd like to be able to enter in a formula which will change the colour of the text in the whole row depending on what date is entered for the expiry date. Each entry uses four cells across a row, so say I was to enter it onto Row 3, it would take up Columns A-D. The entry in Column D is titled "Expiry Date".

I would like to know a relatively simple formula/format which would change the colour of text in the row automatically. I'd like the current date and any dates from the past to show up in red, any dates within the next seven days to show up in orange, and any dates that are in the future outside of those 7 days to show up in green. It would be awesome if we could get them to change each time the spreadsheet is opened, updating depending on the current date.

Can anyone help me with this?

Regards,
Doop

Originally Posted by p24leclerc

You can do this with CONDITIONAL FORMATTING.
It could be tricky with dates so here is an example.
This will always be up to date as it is evaluated every time the sheet is calculated.
Hope this helps

Can you please give me a simple explanation as to how you did that? Also is there any way to stop the colours going down the whole sheet?

Originally Posted by p24leclerc

To set up a conditional formatting, you first click on the HOME tab of the menu. Then you select the icon Conditional Formatting. On the drop down menu, you click on NEW RULE... A window will appear and you'll chose the last option "Use a formula to determine which cells to format".
When you have clicked on this menu, the bottom of the window will change so you can enter your formula and select your desired format for this condition.
Formula are a bit tricky but you can only learn by doing it. So don't be afraid and try anything you want and see how it works.
When you are done, you click OK. You can click again on the Conditional Formatting icon and now you will select the Manage Rules...
You'll see the rule you just created and you will see a column named Applies to. You can click there and change the scope of this rule. You can also add new rules from this window.
Hope it is clear enough for you.

Thank you for showing me that, I appreciate your help thus far. However, there is no option in the drop down menu for "Any time in the past/future", which is the main thing I'm looking for.

Any help in regards to a formula/formatting solution would be greatly appreciated.