deslect by formula

Submitted by jan_rifkinson on 2009/03/11 08:33
Situation:
 
Item w pending (boolean) & datedone (date) columns
 
equation for pending changes background color
boolean = yes, color background
boolean = no, remove color background
 
equation for datedone changes foreground (font) color
date added= font color changes
date removed = new font color removed, ie. revert to default
 
However, these are not combined, i.e.
When I right click check mark or <CTRL>+M, I'd like pending background removed + pending check mark to go away + font color change to take effect
 
I'm assuming I have to combine A or B or C commands in DateDue but don't know syntax
How do I do this?
Thanks.
 
--
Jan Rifkinson
Ridgefield CT USA