Excel - IF Function Problem - Expert Solution

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
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.

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

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc