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.