Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Highlight Data on Report Based on Criteria

Status
Not open for further replies.

cdogstu99

MIS
Jan 17, 2005
68
US
I have a report that is generated based on values chosen by the user from a form. On the report that is generated i want to highlight a certain row of data is above a specific value. For example if my data has company name and number of sales, if the number of sales is over 5, i want to highlight or bold that data on the report. Can someone tell me if there is anyway to do this? Thank you.

 
You can highlight the field(not the row) using Conditional Formatting on the sales field.

Select the field in design view and use Format>ConditionalFormatting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top