It depends how your sheet is set up, but you may be able to use
conditional formatting. For example, if the cell below each subtotal is
always blank, and no other cells in the column are blank, set
conditional formatting to -- Formula Is: =A5=""
where cell A4 is being formatted.
There are instructions in Excel's Help files, and on the following page:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
