How can i get my conditional formating into a vba?

[tonywatsonhelp]

Hi Everyone,
I'm confused? when i record a macro if i create a conditional format it records this for me, but when i go into edit existing ones it does not record this.

is there a way to get all my conditional formats out into either a sheet or a VBA somehow?

thanks

Tony

 

[James006]

Hello,

You can take a look at following:

http://www.vbaexpress.com/forum/sho...onal-Formatting-on-Separate-Sheet-or-Workbook

Hope this will help

 

[tonywatsonhelp]

Thanks I had already seen that but iits not what I need I need to be able to add the code onto a macro so I can run the formatting again and again.

 

[James006]

Re,

If I understand correctly ... you need to adapt your current macro ...

Why don' t you post your current macro ...