"Expired" and "Live" dates.

[Paul1234]

Hi all,

Is there a way of having the words "Expired" or "Live" appear in a cell adjoining a date?
The word "Live" would appear for dates in the future and the word "Expired" would appear for dates in the past.
And, if possible, I'd like to have the word "Expired" appear in black and the word "Live" appear in red.

Many thanks.

[Everstrivin]

put a formula in the cell you want the words to appear such as:

Please Login or Register  to view this content.

this assumes that the date you are testing is in cell A2

to get the color of the words to change, just use conditional formatting using one rule would work, just select the column and go to conditional formatting (under the format menu) and type Live into the first rule and change the format to red the way you want. Press okay, and if it is not working, go back into the conditional format and make sure that the rule appears as ="Live", the problem can be that excel likes to add its own quotes so if you were to enter ="Live" first excel would convert it to =""Live"" which doesn't work, so just go back in and remove the second set of quotes.

Hope this helps.

[Paul1234]

Everstrivin
That works perfectly. Thank you very much indeed.

- Paul