change background color conditionally

Submitted by jan_rifkinson on 2009/03/06 11:25
In a grid:
 
Columns =
 
Item
GTD = boolean
pending = boolean
 
What I want to do is:
 
When "pending" is checked, I want background color to turn yellow
 
How To?
 
Thank you.
 
Edited 03/06/09 12:16 pm: Figured it out but on updated conditional formatting info page I think you need to add that the color code must be in Visual Basic Hex; i.e. in ColorCop right click on color, select mode, scroll down to VBH.
 
--
Jan Rifkinson
Ridgefield CT USA
 
 

date filter

Submitted by jan_rifkinson on 2009/03/04 14:04
I have grid w:
 
item
DueDate
ApptDate
 
I want to filter for week or month for both date types in a single grid.
How do I accomplish this task?
 
Thank you.
 
--
Jan Rifkinson
Ridgefield CT USA