change a rows colour if the todays date is 1 month from the dates in the fields

**andrewd94** · 09-17-2013, 12:12 PM

Hey all first time posting so hope I can get the help I need!

I have a spreadsheet which has multiple data columns.
One of them is a date of when that person passed their test.

I need the rows the change colour from green to red when the date they passed is 30 days away from coming again.
If that makes scene

e.g.
John Smith|23.09.02

(so when the date today is 23.08.03. the cell will change colour from green to red)

Please tell me someone knows how to do this!
I have a cell already in with =(TODAY) so will get the date of the PC every time it starts

Thank you guys! Andrew

**AndyLitch** · 09-17-2013, 07:41 PM

Conditional formatting..
Assuming your data table runs from A6 down and the qualification dates are in column B

1. Select all the cells in the data table
2. Shade all cells green
3. Select conditional formatting
4. Select New Rule
5. Select "Use a formula to determine which cells to format
6. Apply the formula below to the formula box
=TODAY()-((DAY($B6)&"/"&MONTH($B6)&"/"&YEAR(TODAY()))-30)<=30
7. Set the format to shade the cell interior to red

change a rows colour if the todays date is 1 month from the dates in the fields

LinkBack

Thread Tools

Rate This Thread

Display

change a rows colour if the todays date is 1 month from the dates in the fields

Re: change a rows colour if the todays date is 1 month from the dates in the fields

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] using formula to change date a month on and saving dates

changing colour of cell if todays date equals the first day of the month

[SOLVED] colour tabs by todays date

Excel 2007 : I cant auto change a date colour referanced to todays date

Colour a whole line on todays date

Bookmarks

Bookmarks

Posting Permissions