Question description:
This user has given permission to use the problem statement for this
blog.
Need help conditionally formatting dates in a column as follows: Red = less than or equal to today, Yellow = today + 90 days, Green = today + 1 year
Solved by B. H. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/08/2018 - 11:13
Hi
Excelchat Expert
08/08/2018 - 11:13
Welcome to Got IT Pro.
Excelchat Expert
08/08/2018 - 11:13
Please add sample data to apply conditonal formatting
User
08/08/2018 - 11:14
This is Google Sheets not excel
Excelchat Expert
08/08/2018 - 11:14
Ok. You wan to apply it in Google sheets?
User
08/08/2018 - 11:14
No I am working in Excel
Excelchat Expert
08/08/2018 - 11:15
Ok. That is fine. The end result is same.
Excelchat Expert
08/08/2018 - 11:15
You can download the file and open in excel.
Excelchat Expert
08/08/2018 - 11:15
I would like to review the conditions once again.
Excelchat Expert
08/08/2018 - 11:15
Red = less than or equal to today, Yellow = Red = less than or equal to today, Yellow = today + 90 days, Green = today + 1 yeartoday + 90 days, Green = today + 1 year
Excelchat Expert
08/08/2018 - 11:16
What is the difference between Yellow and Green?
Excelchat Expert
08/08/2018 - 11:16
Both have start date as today?
User
08/08/2018 - 11:16
No
Excelchat Expert
08/08/2018 - 11:16
Red = less than or equal to today, Yellow = today + 90 days, Green = today + 1 year
User
08/08/2018 - 11:16
I am trying to determine how close the date is getting using a 3-color scale
Excelchat Expert
08/08/2018 - 11:16
I think, something went wrong, while pasting the data info earlier.
Excelchat Expert
08/08/2018 - 11:17
Ok.
Excelchat Expert
08/08/2018 - 11:18
In that case, i have to apply formula to calculate the number of days from today().
Excelchat Expert
08/08/2018 - 11:25
What about after 90 days till one year? I hope, you have to consider it after 90 days
Excelchat Expert
08/08/2018 - 11:26
Then, you can apply 3 point scale.
User
08/08/2018 - 11:27
We can do 180 days
Excelchat Expert
08/08/2018 - 11:27
Ok.
User
08/08/2018 - 11:28
So anything before today is red, anything after 1 year is green, and anything in between is a scale?
Excelchat Expert
08/08/2018 - 11:29
Ok. I am taking look at it.
Excelchat Expert
08/08/2018 - 11:33
Please refer the preview.
Excelchat Expert
08/08/2018 - 11:34
I have applied Min and Middle range as 0 and max range as 365.
User
08/08/2018 - 11:37
I see how to do it now
User
08/08/2018 - 11:37
THank you
Excelchat Expert
08/08/2018 - 11:37
You are welcome.
Excelchat Expert
08/08/2018 - 11:37
Please do visit Got It Pro. We have 24 * 7 problem solving facility. You can visit any time.
Excelchat Expert
08/08/2018 - 11:37
Have wonderful day ahead. Please end the session and leave valuable feedback.
Excelchat Expert
08/08/2018 - 11:52
Please change the middle range to 180 to get close approx.
Excelchat Expert
08/08/2018 - 11:52
Visit Got IT Pro.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.