Topic: How to turn cell into green with a specific condition?
Hi guys, I would just like to ask how to turn the cell red if the date is 5 days after the document is received but it would overwrite it and turn green if the status on the dropdown box says "for printing, For dissemination to concerned offices and filed".
I was able to find the same issue with this one.
http://myvisualdatabase.com/forum/viewtopic.php?id=5283
I tried to use the same script and only able to turn it to green but cannot turn overdue documents to red.
also I'd like to thank Derek for helping me with this project.
Any help is appreciated.
Thanks guys.