Ok guys Basically i have a spreadsheet using conditional formatting, and have it set so it changes color based on range of dates ie( if its beyond 365 days the cell turns red, if its under a year the cell turns green. Ive pasted one of the rules below in case i didnt explain clearly.


=AND(F4>=TODAY()-305,F4<=TODAY()) <-- and set color to green


What I want to do is have the Cell auto fill with Text " Up to Date" or Out of Date based on the date entered in source cell. Any help would be greatly appreciated.

Thanks