Need to highlight rows in report depending on a field

G

Guest

I want to colour highlight rows depending on the information in a particular
field. Conditional formating the field will only colour that specific field
and not the entire row of information
 
R

Rick B

apply the conditional formatting to ALL the fields in that row. A
"condition" does not have to evaluate the current field. For example, if
you have five fields in a row, you could apply the same format to each field
in the row.

Field1 format states... If field5 is true, then make this field blue
Field2 format states... If field5 is true, then make this field blue
Field3 format states... If field5 is true, then make this field blue
Field4 format states... If field5 is true, then make this field blue
etc.
 

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