Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting subtotaled cells
I am subtotalling data via a macro, and would like the cells in the entire
subtotal row to all be bold, like the row header cell (e.g. "999 Total" and "Grand Total"). I'm trying to make the subtotaled data stand out from the detail data. |
#2
|
|||
|
|||
One way would be to use conditional formatting,
assume the category is column B and the numeric totals are in C starting with the first numeric value in C2, select from C2 to the last value in C with C2 as the active cell, do formatconditonal formatting formula is =ISNUMBER(FIND("Total",B2)) click the format button and select bold fonts and click OK twice -- Regards, Peo Sjoblom "joe sp" <joe wrote in message ... I am subtotalling data via a macro, and would like the cells in the entire subtotal row to all be bold, like the row header cell (e.g. "999 Total" and "Grand Total"). I'm trying to make the subtotaled data stand out from the detail data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Formatting cells in Excel for certain Values to appear certain Col | Excel Worksheet Functions | |||
Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |