Question description:
This user has given permission to use the problem statement for this
blog.
I recently had another got it pro agent make it so the format of the "due date" column changes color with the date. He didnt make it so it goes red when the date is PAST due, instead it will not format the cells. Please fix? Thanks.
Solved by O. Q. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
21/09/2018 - 10:09
Hey, I am in a major rush. Please use this file
[Uploaded an Excel file]
Excelchat Expert
21/09/2018 - 10:09
Welcome to ExcelChat!
Excelchat Expert
21/09/2018 - 10:10
OK
User
21/09/2018 - 10:10
Yes i agree only one question per session. lol
Excelchat Expert
21/09/2018 - 10:10
You Got it!
Excelchat Expert
21/09/2018 - 10:11
I have opened the file
Excelchat Expert
21/09/2018 - 10:11
So
Excelchat Expert
21/09/2018 - 10:12
What are the conditions you need
User
21/09/2018 - 10:12
the same conditions that are already existing, but i need the cell to go red even when the date is past due.
User
21/09/2018 - 10:13
Right now it will only go red when the date is today or within 3 days, not when it is yesterday and before
User
21/09/2018 - 10:13
So any day before today it also needs to format the cell red in color
Excelchat Expert
21/09/2018 - 10:13
OK
Excelchat Expert
21/09/2018 - 10:13
Got it
Excelchat Expert
21/09/2018 - 10:13
Working on it now
Excelchat Expert
21/09/2018 - 10:15
Almost done
Excelchat Expert
21/09/2018 - 10:17
Any day before today
Excelchat Expert
21/09/2018 - 10:17
Right? I see some other conditions
User
21/09/2018 - 10:17
today and before. ALONG with the other conditions
User
21/09/2018 - 10:17
The other conditions must remain
Excelchat Expert
21/09/2018 - 10:18
Ok
Excelchat Expert
21/09/2018 - 10:19
[Uploaded an Excel file]
User
21/09/2018 - 10:20
Wrong,
Excelchat Expert
21/09/2018 - 10:20
What is the issue?
Excelchat Expert
21/09/2018 - 10:21
I can fix it right now
User
21/09/2018 - 10:21
It needs the same conditions as what was one there before. BUT I need it to change red before the date of today ALONG with 3 days from today...
User
21/09/2018 - 10:21
And when the cell is blank no formatting.
Excelchat Expert
21/09/2018 - 10:21
Got it
Excelchat Expert
21/09/2018 - 10:22
Just 3 days from today
User
21/09/2018 - 10:22
basically the exact same condition youre just changing the red from from 3 days today. To from 3 days today AND if the date is passed
Excelchat Expert
21/09/2018 - 10:23
[Uploaded an Excel file]
User
21/09/2018 - 10:24
wrong
Excelchat Expert
21/09/2018 - 10:24
Let me know if this solution is what you need
User
21/09/2018 - 10:25
"sept 17" should be in RED because its before today.
Excelchat Expert
21/09/2018 - 10:25
What about the 3 days you said?
User
21/09/2018 - 10:26
I said keep the same conditions that were there before, just make it so the cell turns RED when its before today
User
21/09/2018 - 10:26
Because what it did before, was the formatting was right, but when the date was yesterday or before it would un-format the cells
Excelchat Expert
21/09/2018 - 10:26
Ok
Excelchat Expert
21/09/2018 - 10:28
[Uploaded an Excel file]
User
21/09/2018 - 10:28
Wrong...
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.