display conditional formatting rules

Topic

New Reply

Hi Loungers,

Does anyone know how to display the current set of conditional formatting? I don’t want to go to the cells I want a listing of all the conditional formatting rules. I am sure I have seen this somewhere in the past but cannot locate it.

many thanks

liz

Reply | Quote

Replies

I have not played with this, but the code at http://dailydoseofexcel.com/archives/2010/04/16/listing-format-conditions/ may be adaptable.

Steve
PS I beleive that code should work for XL2007 and up. FOr XL97-2003, the code at http://www.contextures.com/xlCondFormat04.html should work.

Reply | Quote