I am trying to turn the row green when I have completed the job and enter the date of completion .
I am trying to turn the row green when I have completed the job and enter the date of completion .
use conditional formatting
mark all row (say 2nd) and new conditional formatting rule based on formula would be
=$D2>0
assuming your date is in column D
and use green fill as formatting.
Best Regards,
Kaper
Thanks Kaper I seemed to be making it a lot harder than it needed to be most helpful.
There are currently 3 users browsing this thread. (0 members and 3 guests)
Bookmarks