# Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at