|Your first request was;|
I want a way that highlights a cell if B2 is more than 7 days before today but only if c2 is blank.
The last formula I posted will do that using Conditional Formatting.
Now you want:
If the date in B1 is within the last week the text in A1 should be "OK" if its over a week it should be "OUTSTANDING".
I think I understand what you want, but could you post an example, just so I'm sure of what you mean by
is within the last week
over a week it
Dealing with Date terminology can be tricky.