how to apply conditional formatting of one field to whole record


F

FionaS

Hi, I wish to change the background colour of record based on one of two
possible choices selected in one of the fields.

I have applied conditional formatting successfully to that field, but have
failed to find a way to apply the same format to the rest of the fields for
that record.

Thanks for all suggestions in advance.

Regards
Fiona
 
Ad

Advertisements

K

Ken Sheridan

Fiona:

Apply conditional formatting to each of the other controls using:

Expression is: [YourOtherField] = "Your choice"

If the other field is a Boolean (Yes/No) data type then the expression would
be:

[YourOtherField] = True

if the conditional formatting is to be applied for a 'Yes' (False for a 'No').

Ken Sheridan
Stafford, England
 
Ad

Advertisements

R

Roger Carlson


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top