Prev: Recalculate a worksheet following an autofilter selection.
Next: Copy and paste sheets to new workbook
From: andreashermle on 7 Jun 2010 07:27 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 |