Conditional formatting is one of those things that will get simpler more reliable. But in IQ's beta stage, it's not a priority at the moment (what is ? Calendar, filtering and grid UI, search and replace, important bugs...).
Rules at this point are (explained there : http://www.sqlnotes....index.php?q=node/219
1- conditional format doesn't admit other criteria than numbers. If it's a Y/N (Boolean) Field, then -1 = Y (<>0 in the cond. Format. win.) and 0 = N (=0 in the cond. Format. win.) (as it is, traditionally).
2- You MUST "save" in the field management dialog after changing a conditional formatting option -- even if autosave is on. This is a bug I discovered last week.
3- If a columns format is conditioned by another column, both need to be present in the grid for the formatting to happen
4- The grid must be closed an reopen for the modifications to appear.
If your criteria is some text, then you'd need to use a VB function in the visual basic editor. Not for the "normal" users right now.
And then there are several approaches : insert the criteria in the CalcColor() function which will fully color the item, or create a separate function which will affect a Y/N field that you'll then be able to use as a criteria in the conditional format section of the manage fields window.
If you really want to do that, I can help you... Or you can wait for the conditional formatting to support strings.
(P.S. : The =4 in the screenshot was a reminder for myself. I used a number that had no effect since I wanted to keep the BackColor info for future reference.)