I think I need IF, AND, ISBLANK

[BexJ78]

Hi

I have a sheet set up to track when a document has been requested. I have 3 columns for the 3 requests I make for I pass it to someone else to chase.

What I am trying to do is get the words RED or GREEN in column D, depending on if the most recent request is under or over 7 days old.

I can do this for 1 column but I am unable to get the formula to ignore the first column if there is something in the second and then ignore the first and second if there is a date in the third column.

If you need any further information from please let me know.

 

[SyedUsman]

Try this in d2 & let me know

=if(today()-if(c2="",if(b2="",a2,b2),c2)>7,"green","red")

 

[BexJ78]

That's great seems to do the trick. Thank you so much for your reply