conditional formatting on report

[_Bigred]

I have a report that has 6 columns

Rank, Last Name, First Name, Number, Recv Date,
OrigUnit,Restrictions,SingleResponse.

The report is the above (6) columns with 164 records (rows) of data.

I would like to bold the entire ROW of each record that has "Yes" in the
SingleResponse column.

I know I can use conditional formatting for a individual box, based on it's
value. But how do i do a whole row based on one box/cells value???

TIA,
_Bigred

 

[Allen Browne]

You can use conditional formatting on *each* control.
Expression ... [SingleResponse] = True

 

[_Bigred]

I was hoping these was a way to select "all the fields" and do conditional
formatting instead of having to select each individual field manually.

Thanks,
_Bigred

You can use conditional formatting on *each* control.
Expression ... [SingleResponse] = True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that has 6 columns

Rank, Last Name, First Name, Number, Recv Date,
OrigUnit,Restrictions,SingleResponse.

The report is the above (6) columns with 164 records (rows) of data.

I would like to bold the entire ROW of each record that has "Yes" in the
SingleResponse column.

I know I can use conditional formatting for a individual box, based on
it's value. But how do i do a whole row based on one box/cells value???

TIA,
_Bigred

 

[Allen Browne]

Yes, you can do that.

Select the fields you want, choose Conditional Formatting from the Format
menu, and enter the expression.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I was hoping these was a way to select "all the fields" and do conditional
formatting instead of having to select each individual field manually.

Thanks,
_Bigred

You can use conditional formatting on *each* control.
Expression ... [SingleResponse] = True

 

[_Bigred]

Thanks Allen.

Yes, you can do that.

Select the fields you want, choose Conditional Formatting from the Format
menu, and enter the expression.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I was hoping these was a way to select "all the fields" and do conditional
formatting instead of having to select each individual field manually.

Thanks,
_Bigred

You can use conditional formatting on *each* control.
Expression ... [SingleResponse] = True