hello,
I have my own business and I need to find away to highlight cells when my payments are either due or overdue.
I have attached a screenshot and the sheet
thank you
hello,
I have my own business and I need to find away to highlight cells when my payments are either due or overdue.
I have attached a screenshot and the sheet
thank you
Try
In conditional formatting
For yellow TODAY()>=D4
For red =NOT(TODAY()>=D4)
Check the attached file
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks