Been a while since my last post, but I too am back!.....
I think I have a realitively easy thing to solve, but I am stumped. I will have a simple file consisting of 2 columns. the first is text data, the second will be in date format. I need to set up conditional formatting that does the following:
1) if Date is Past current date format cell Red
2) if date is within 2 weeks of current date, format Yellow
3) all else, = Green