Conditional Formatting a Record based on Yes/No Box

[TylerTand]

I have a field named: Target that has a check box (Yes/No) option. I want to conditionally format the record so that it shows up with a red background if the Taget field is Checked (Yes) in a query. Can someone help me with this? Thanks

 

[WayneRyan]

Tyler,

Just choose Conditional Formatting and use:

"Field Value Is" --> "Equal To" --> "True"

Wayne

 

[TylerTand]

For some reason you can't conditionally format the check box (yes/no) But what I really want is for the whole record's background color to change if the Target check box is selected. It works if you use a yes or no Text field with a list lookup, so maybe that will have to do. But it only highlights that box and not all the fields in the record. If you can help with getting it to apply the background color change if one field fits the criteria I would appreciate the help. Thanks.

 

[WayneRyan]

T,

If you want the whole row to be highlighted, the only way that I know of
is to go to each field and set the conditional formatting:

"Expression Is" --> [YourBooleanField]

hth,
Wayne