Conditional Formating-color of word to change to green

[hodkd]

I am trying to put 3 conditions in a text cell: If a Cell has the word "open" in it I would like the color of word to change to green if the current date is less than 45 days from a date cell, yellow if the current date is greater than 45 days and less that 60 days from the date cell, and red if the current date is 60 days over the date cell, and if another word is put in the cell, such as "closed" the color will stay the default color.

[Paul]

Hi hodkd,

Try these conditional formats:

First condition (Formula Is):
=AND(A1="Open",D1>TODAY()-45)
Format as Green font

Second condition (Formula Is):
=AND(A1="Open",D1>TODAY()-60,D1<=TODAY()-45)
Format as Yellow font

Third condition (Formula Is):
=AND(A1="Open",D1<=TODAY()-60)
Format as red font

These assume cell A1 is going to (possibly) have the text "Open" in it, and that cell D1 will have the date you're testing against Today. Adjust your formulas to suit.

[hodkd]

Hi Paul, thank you very much, that works perfect.

Ken