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!

Format Rows based on Same Data

Status
Not open for further replies.

Nilgni

Instructor
Feb 21, 2002
58
US
Is it possible to 'conditional format' accross rows?

Name Value Team

Bill 12 Devils
Keith 9 Colts
Jim 9 Eagles
Kevin 7 Pioneers


I want to bold the two nines so that they stand out as a tie.

Thanks,
Keith
 
you can have a hidden control on the row which is a count of the number of times a particular value has occured, for this you need to group the underlying query...

then you just have conditional formatting on the hidden control...

--------------------
Procrastinate Now!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top