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.