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. |
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. |
All times are GMT +1. The time now is 04:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com