Submitted by jan_rifkinson on 2011/10/28 13:24
In field equations I want an item to change to a specific color if two criteria are present
 
If item is bold
and
if item is assigned to field daylogs
 
I'm assuming this belongs in daylogs field equation (or should it be in item field equation?.
but don't know the syntax.
Any help would be appreciated.
Thank you.

Comments

Hi Jan,
 
Conditional formatting is still a bit tricky. But you could try to insert that in the item field conditional formats section:
 
For Criteria  :
[itemfont] <> "" AND [daylogs] <> 0
 
For Color (pick your own... this is orange) :
backcolor=&h009BFF
 
 
What this does is to Color your item field when a special font is applied (bold, italic, etc.) and when day logs is checked.
 
I understand you'd like to have "bold"  to trigger the Color... I tried ([itemfont]  =  "||B|") , but for some reasons, it doesn't work. Maybe this function isn't enabled yet.
 
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

jan_rifkinson

2011/11/03 19:59

Permalink

Hi Armando. Sorry I didn't reply sooner. Had Oct snow storm - biggest in CT history -- and lost power from Sat until Today 2011/11/03 @ 17:30 . Thanks very much for the equation. I tried everything I could think of with Bold but it didn't work either.  It seems a mystery but thanks very much for your help. It is much appreciated. I'm also looking forward to seeing your work on the new calendar. Maybe a Xmas present for those of us who have been good all year ?

Armando

2011/11/06 21:33

Permalink

No worries!
Yes, I heard about that snow storm! Crazy...!
As I said, I don't think you can really trigger a format based on a "bold" condition. Maybe it will be possible in the future, but right now, it seems like a hit/miss thing.
 
There a few issues with conditional format which need to be solved :
 
- syntax isn't  perfectly standardized : sometimes a space before the operator will cause the formatting to not function.
- negative numbers (used as conditions, e.g. : value<0) don't have any effect, unless the grid is refreshed.

 [As for the calendar : it's obviously IQ's next big feature, and Pierre's main goal AFAICT... :) ]
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Pierre  : note that "backcolor=&h009BFF" works but "backcolor = &h009BFF" (with spaces around the operator) doesn't.
 
Makes getting conditional formatting right... a bit trickier.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz