how to apply conditional formatting of one field to whole record

  • Thread starter Thread starter FionaS
  • Start date Start date
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
 
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
 
Back
Top