Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i need a formula that will change the background color of a cell after a certain time period. Such as if I enter todays date it will change to Red after 12 months. Is this possible?
Solved by I. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/06/2018 - 07:02
hello dear
Excelchat Expert 12/06/2018 - 07:02
lcome to excel chat
User 12/06/2018 - 07:02
hello
Excelchat Expert 12/06/2018 - 07:02
Hope that you are well..
Excelchat Expert 12/06/2018 - 07:02
ow can I help you plz....?
User 12/06/2018 - 07:03
i need a formula that will change the background color of a cell after a certain time period. Such as if I enter todays date it will change to Red after 12 months. Is this possible?
Excelchat Expert 12/06/2018 - 07:03
You want to change the colour of cell acording to date
Excelchat Expert 12/06/2018 - 07:03
Am I right?
Excelchat Expert 12/06/2018 - 07:04
Are you there?
User 12/06/2018 - 07:05
yes I want it to auto change according to the date entered. so if I put in todays date it will turn green but will automatically turn red after a certain period of time
Excelchat Expert 12/06/2018 - 07:05
ok dear... I got it
Excelchat Expert 12/06/2018 - 07:05
This can be done with conditional formatting
User 12/06/2018 - 07:06
ok
Excelchat Expert 12/06/2018 - 07:06
Do you have a particular file on which you want to do this or may I create a sample file for you?
User 12/06/2018 - 07:06
sample would be helpful
Excelchat Expert 12/06/2018 - 07:07
ok dear
Excelchat Expert 12/06/2018 - 07:07
Would you wait for a while... Let me do work for you.
User 12/06/2018 - 07:07
sure.. do you want to email it to me?
User 12/06/2018 - 07:08
I am seeing only 13 min remain on the time clock in the corner
Excelchat Expert 12/06/2018 - 07:08
No No dear
Excelchat Expert 12/06/2018 - 07:08
Dear I need a little time
Excelchat Expert 12/06/2018 - 07:09
Plz Wait for a while
Excelchat Expert 12/06/2018 - 07:09
you can extend the session for 20 more minutes... Don't worry
Excelchat Expert 12/06/2018 - 07:11
Hy dear
Excelchat Expert 12/06/2018 - 07:11
you there
User 12/06/2018 - 07:11
yes
Excelchat Expert 12/06/2018 - 07:11
Would you know something about Conditional formatting
User 12/06/2018 - 07:12
i have used it in the past but it has been a long time
Excelchat Expert 12/06/2018 - 07:12
Ok Let me guide you.
Excelchat Expert 12/06/2018 - 07:13
Go to Conditional formating>>> Highlight Cells Rules>>>Greater than
Excelchat Expert 12/06/2018 - 07:13
A dialogue box appears .....
Excelchat Expert 12/06/2018 - 07:14
write down this formula in box....
Excelchat Expert 12/06/2018 - 07:14
=today()+365
Excelchat Expert 12/06/2018 - 07:15
And select formatting according tyour requirement... and then click "ok"
Excelchat Expert 12/06/2018 - 07:16
Hy are you there?
User 12/06/2018 - 07:16
yes
Excelchat Expert 12/06/2018 - 07:17
You Understand or not?
User 12/06/2018 - 07:17
yes thank you
Excelchat Expert 12/06/2018 - 07:19
If tou still need help... I gave you a screen shot
Excelchat Expert 12/06/2018 - 07:19
Check this....
[Uploaded an Excel file]
Excelchat Expert 12/06/2018 - 07:20
Satisfied???
User 12/06/2018 - 07:20
yes thank you
Excelchat Expert 12/06/2018 - 07:20
Ok dear
Excelchat Expert 12/06/2018 - 07:20
Take care keep smiling
Excelchat Expert 12/06/2018 - 07:21
Thanks alot for visiting 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.