Highlighting sub-totals in yellow?

Bernard2

New Member
Joined
Jun 15, 2011
Messages
44
How do I highlight every Total (bold) in yellow, in the excel spreadsheet below, without manually going to each cell in the spreadsheet and changing the fill to yellow?

VHA12SMITHAT Total
VHAV16ADAMSR Total
VHAV16ADKINJ Total
VHAV16AldriM Total
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,791
Select the range and apply conditional formatting

1594609844556.png




1594609820768.png
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
CTRL-F, find what "Total", Find All
CTRL-A, Close the find dialog box
CTRL-1, then the yellow format
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,730
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If they are actual subtotal rows added using the subtotal feature, you can collapse the outline to only show the totals, select them, then press Alt+; to select just the visible cells (or use the Goto/f5 ... Special option) and then format them as needed.
 

Bernard2

New Member
Joined
Jun 15, 2011
Messages
44

ADVERTISEMENT

Thanks! But, how do I highlight the entire row where the Total is located?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,730
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you're using my method, select the entire rows before pressing Alt+;
 

Bernard2

New Member
Joined
Jun 15, 2011
Messages
44

ADVERTISEMENT

I still can't get the entire rows to highlight yellow.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,730
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Then either you have something clearing the formatting (eg conditional formatting) or you didn't select the entire rows to start with. Do the entire rows appear selected before you press the button to change the fill?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,730
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I suggest you don't then. ;) If it's not a collapsible subtotal setup, use an autofilter then select the rows and use the Alt+; trick.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,173
Members
417,129
Latest member
geekzilla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top