How do I get the Count numbers to automatically appear in Bold?

  • Thread starter Thread starter pres9114me
  • Start date Start date
P

pres9114me

I'm doing a Count action in a spreadsheet. (Counting the number of
times a name appears in the data) I click on the first cell in the
column and then click on Data dropdown, Subtotal, count. As a result,
Excel adds a row in between different name groups, puts in "JOHN SMITH
Count" in bold in one cell, and then the number of instances the same
name appears in another cell. However, the number itself isn't in bold
and I'd like it to be. Is there some way to format this action to have
the number automatically appear in bold font, other than going to each
instance and bolding it manually?

Thanks for your help
 
Hi
try the following:
Assumption: column A hold the SUBTOTAL line and column B the values:
- select column B
- goto 'Format - Conditional Format'
- enter the following formula
=ISNUMBER(FIND("Subtotal",$A1))
- choose your format for these cells
 
Back
Top