Unable to make a cell change colour depending on another cells date.

Hello, I will try to explain this clearly.

I am having an issue with a formula.

I would like a cell to turn from green to red if a date in different cells goes beyond todays date.

For example, if the date in a cell isn't changed to todays date or a date in the future, a separate cell turns from green to red.

Does anyone have any tips?

Kind Regards Robert.

Hi and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(Since this is your first post I'll change the title for you but please note for the future.

You also need to define "expires"

Does that mean is before TODAY() or something else?

You may use conditional formatting for this as
select the cells where date are

2 rules

For green
=if(a1<=today(),true,false)

For red

=if(a1>today(),true,false)

a1 is the current cell of range
Thanks

Hi, we3lcome to the forum

To begin with, the IF() statement is redundant, Conditional Formatting ONLY works on TRUE or FALSE, and a1<=today() will either return a TRUE or FALSWE anyway. Also, if you use regular formatting to make all cells green, you only need 1 rule...

=a1>today()

This is simply testing to see if the date in cell A1 greater than today's date. If it is, the CF rule will trigger, if it is not, the rule wont apply

For using how to use conditional formatting visit this link

http://www.gcflearnfree.org/excel2010/19/print

In the 4th step click new rule and then the last option (use a formula ......)

I think other things will not be to difficult.

Regards