Question description:
This user has given permission to use the problem statement for this
blog.
i would like the cell to become red if the date in the cell exceeds "NOW"
Solved by K. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
08/09/2017 - 09:55
Hello, I understand that you would like to conditional format a cell if it exceeds now, right?
User
08/09/2017 - 09:55
i have appointments scheduled on a spreadsheet. appointments should be three monthly so i have appointment date in one column
User
08/09/2017 - 09:56
then i have a+90 to schedule the next three monthly appointment
Excelchat Expert
08/09/2017 - 09:56
I could give you the generic formula for this but it would also be a lot easier for if you could upload your file so I can work on it.
User
08/09/2017 - 09:56
i would like that to highlight if the next due appointment is overdue
Excelchat Expert
08/09/2017 - 09:58
Still with me?
Excelchat Expert
08/09/2017 - 09:58
I don't mean to rush you but we have a very limited amount of time to help you so it would be best if we can get started now.
Excelchat Expert
08/09/2017 - 10:00
Hello.
Excelchat Expert
08/09/2017 - 10:00
I'll just be giving you the generic formula to use then. Please give me a few minutes.
User
08/09/2017 - 10:01
is that possible?
Excelchat Expert
08/09/2017 - 10:01
=a1>NOW() is the formula you need to test a cell is greater than now().
Excelchat Expert
08/09/2017 - 10:01
And the reason why you were getting an error in the document preview is because I think you are trying to write the date in a EU format.
Excelchat Expert
08/09/2017 - 10:02
The sheet to the right is programmed to accept in US format.
Excelchat Expert
08/09/2017 - 10:02
The formula must contain both a column and a row number unless you are referencing an entire column.
Excelchat Expert
08/09/2017 - 10:02
In your case it should be =A1+90
Excelchat Expert
08/09/2017 - 10:04
If you'll look at column D, I made it so that whatever it is that's greater than NOW() gets highlighted.
Excelchat Expert
08/09/2017 - 10:05
Column D is the date in column C +90 days.
Excelchat Expert
08/09/2017 - 10:05
Entering Explanation Phase
Excelchat Expert
08/09/2017 - 10:06
The exact formula for the custom conditional formatting is =D1>=now()
Excelchat Expert
08/09/2017 - 10:06
Entering Discussion Phase
Excelchat Expert
08/09/2017 - 10:06
Do you have any questions regarding the solution provided?
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.