View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andreashermle andreashermle is offline
external usenet poster
 
Posts: 123
Default Shading cells that contain formulas and conditional formatting at thesame time.

Dear Experts:

I got cells in one table of a worksheet that contain ...

.... formulas as well as conditional formatting (i.e. there are cells
that contain both attributes)

I would like to fill these cells (containing formulas as well as
conditional formatting at the same time) with a certain shadefill (RGB
177, 177, 177) with the aid of a VBA macro.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas