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
 
 

Comments

Conditional formatting is for individual cell formatting.
 
If you want to change the whole item back color, there is a much simpler way:
  1. In Auto-assign of the field Pending, enter: A:ItemColor="yellow"|E:ItemColor=