Cell auto colour change by date in cell

October 1, 2020 at 06:38:46
Specs: Windows 10
Hi, I have looked everywhere and cannot find the answer. I have a large spreadsheet that I enter start dates onto, I need the dates to be green if they are within 27 days of the entered date, turn amber if they are 28 - 34 days from the entered date and to turn red if they hit 35 days. It has nothing to do with todays date, just the date entered onto the spreadsheet.

I am a total novice so apologies for all the questions that I will ask and appear not to understand.

Thanks

Shell

message edited by Shellthenovice


See More: Cell auto colour change by date in cell


#1
October 1, 2020 at 11:28:22
Your requirements are not clear. Please keep in mind that we can't see your worksheet from where we are sitting.

re: "I have a large spreadsheet that I enter start dates onto, I need the dates to be green if they are within 27 days of the entered date"

You say that enter "start dates" and then you say that you need "the dates" to be a different color based on how far they are from the "the entered date".

"Start dates", "the dates", "the entered date".

I can't tell which dates are which. In addition, without knowing how your worksheet is set up (rows, columns, where are the various dates, etc.) it would be difficult for us to offer any suggestions.

If you could clarify your question a little bit and let us know how your spreadsheet is laid out, we'll see what we can do.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
October 1, 2020 at 12:47:35

Reply ↓  Report •

#3
October 2, 2020 at 08:30:22
Thank you. I will look at those links over the weekend and let you know.

I just have dates in the E column, I would like the cells to be green up to 27 days after the date I have entered, change to amber 28-34 days after the date and red after that. So I would have a list of dates in column E, but the cells in column E would be one of three colours depending on how many days it is after the date I had entered.

Thank you for your time and response, I will update on Monday.


Reply ↓  Report •

Related Solutions

#4
October 2, 2020 at 08:45:22
re: "I just have dates in the E column, I would like the cells to be green up to 27 days after the date I have entered"

You still haven't told us where you are entering the date.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

Ask Question