View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil Chamberlin Phil Chamberlin is offline
external usenet poster
 
Posts: 1
Default How to set a conditional format that is dependent on cell type

I have a worksheet that I perform a subtotal on using the subtotal wizard in
the Data toolset. The wizard inserts a row and the subtotal formula based on
the criteria entered. Therefore, the preceding cells (non-uniform range) are
values and the inserted row is a formula. I would like to bold the inserted
cells (the ones with the Subtotal formula).