highlight subtotal rows with a fill color
I want to highlight the subtotal rows with gray fill color so they stand out.
Can this be done without "pasting" the format from one row to the rest |
highlight subtotal rows with a fill color
Use conditional formatting, select the table except for the headers and use
something like Formula is =ISNUMBER(SEARCH("Total",$A2)) where A2 would be the first cell below the header click format, then pattern and select grey then click OK twice -- Regards, Peo Sjoblom "Deb Raskob" <Deb wrote in message ... I want to highlight the subtotal rows with gray fill color so they stand out. Can this be done without "pasting" the format from one row to the rest |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com