Submitted by David_H on 2019/12/27 20:49
To Pierre, I did RTFM :-). To anyone else, please also assist if you know the answer :-).
 
When a yes/no field I have named Focus is checked in a grid, I want the corresponding Focus item in that grid to have a certain background color. So on the Item field under conditional formatting, I have tried numerous entries. Based on the manual I would think it is supposed to be the first one below:
 
[Focus]=<>0
The screenshot at the bottom of the page contradicts the manuals written instructions, so I also tried Focus<>0 and also tried
Focus="<>0" and also tried
[Focus]="<>"
 
The background color is entered correctly and I do have "use" checked. How should I enter this?
 
Thanks!
 

Comments

Hi David,
 
This worked just fine here. In the Item field:
  • Use? : checked
  • Criteria: [Focus]<>0
  • Formats: BackColor=&H00FFFF
  • Grids: Your grid name
Perhaps it is the extra '=' that is causing it to not work
 
Pierre_Admin
IQ Designer
 

Thank you. My mistake is that in my other conditional formatting that works I have it in actual quotes, for instance:
[Status Selection Text]="Closed". So I was also entering this in quotes which evidently in the case of a yes/no field stops it from working.