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