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!

Register Log in
  • 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!

Top 10 Formatting 1

Status
Not open for further replies.
Topcat04

Topcat04

Technical User
Sep 14, 2007
121
GB
Hi There

Can you help me with a solution that will highlight my complete row when using the Top 10 conditional formatting in Excel 2007.

Currently it only highlights the cells in the column the top 10 is being based on.

Thank you in advance,
 
Sort by date Sort by votes
Why don't you select the rows, then do Conditional Formatting with a formula to decide formatting, like:
Code: 
=RANK($B2,$B$2:$B$16)<=10
... replacing the B2 and B2:B16 with the relevant ranges for your data.



Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Upvote 0 Downvote
Excellent! Thank you Glenn - just the advice and solution I was looking for.

Cheers!
 
Upvote 0 Downvote
My pleasure :-D

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sxschech
  • Locked
  • Question
Pie Chart with linked updatable data table formatting 1
Replies
17
Views
373
combo
combo
remeng
  • Locked
  • Question
Power BI - Conditional Formatting on value issue
Replies
0
Views
145
remeng
remeng
sxschech
  • Locked
  • Question
Excel Conditional Formatting and Non VBA solutions
Replies
17
Views
242
sxschech
sxschech
AndyBellers
  • Locked
  • Question
Regarding: thread68-1090780 If y
Replies
0
Views
161
AndyBellers
AndyBellers
keithinoz
  • Locked
  • Question
excel conditional formatting
Replies
6
Views
165
keithinoz
keithinoz

Part and Inventory Search

Sponsor

Back
Top