Hey everyone,
Hopefully I can explain this correctly here.
I am creating a Job Book which has all the pertinent information connected to it. I want to have a formula so that if the invoice date is over 30 days old, then the entire row will turn red. However, it should not turn red if there is a date paid entered (meaning it is complete).
Any help would be great.
I attached the file here. I want the entire row red if the value in Column K (Invoice Date) is over 30 days old and there is nothing listed in Column L.
Thanks,
-Todd DeBacker
Bookmarks