New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Conditional formatting - top 6 values need to be italicized

Macros, VBA, Excel Automation, etc.

Conditional formatting - top 6 values need to be italicized

Postby mikeytheb » Thu Jun 23, 2016 8:53 am

My spreadsheet has 8 rows that I need to manipulate a little.
I want to format the top 6 values to be italics. I have another formula that uses the italicized cells for other calculations.

Example data
B3 C3 D3 E3 F3 G3 H3 I3 J3 K3
0.02% -0.24% 1.15% 0.86% 0.93% 1.08% 3.38% 0.82% 1.21% 1.29%
0.07% -0.20% 0.03% -0.28% -0.76% -0.58% 0.66% -0.81% -0.74% 0.28%
0.11% 0.14% -0.14% -0.39% -1.95% -0.59% -0.28% -0.79% -1.62% 3.18%

L3 M3 N3 O3 P3 Q3 R3 S3
0.91% 1.04% 1.36% 1.58% 1.66% 0.35% 0.78% 2.02%
-0.01% 0.02% 0.11% 0.17% 0.19% 0.02% -0.02% 0.35%
0.04% -0.01% -0.07% -0.17% -0.22% 0.66% 0.88% -0.54%


I have been looking through and formatting them manually, but I would like to automate this - the data changes weekly.
  • 0

mikeytheb
Rookie
 
Posts: 2
Joined: Jun 23, 2016
Reputation: 0
Excel Version: 2013

Re: Conditional formatting - top 6 values need to be italicized

Postby NoSparks » Fri Jun 24, 2016 12:29 am

Can you define "the top 6 values" ?
Is that per column, per row or overall ?
What would your expected result be if 6 cells contained the same "first top" value or, in the extreme, all cells contained the same value ?
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: Conditional formatting - top 6 values need to be italicized

Postby mikeytheb » Tue Jun 28, 2016 12:56 pm

NoSparks wrote:Can you define "the top 6 values" ? Highest value - numerically - relative value as sometimes all entries are negative.
Is that per column, per row or overall ? Per Row
What would your expected result be if 6 cells contained the same "first top" value or, in the extreme, all cells contained the same value ?
That has not happened so far, but if it did, I guess it would be ok (for that week's data) to format the first six it found.
  • 0

mikeytheb
Rookie
 
Posts: 2
Joined: Jun 23, 2016
Reputation: 0
Excel Version: 2013


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 30 guests