How to find all conditional formating cells in VBA?

[jaryszek]

Hi Guys,

i want to check every worksheet in which cells there is conditional formatting and if it is incorrect (i mean highlighted) i want to know exactly which cell it is.

Any ideas how to do this?

I was thinking to use Goto Special method --> filter conditional formatting but hmmm it is the best approach?

Please help,
Jacek

[alansidman]

https://stackoverflow.com/questions/...nal-formatting

[jaryszek]

thanks!

It is not best method,
problem solved:

Please Login or Register  to view this content.

Jacek