Macros and conditional formatting

**skalus** · 11-22-2013, 12:49 PM

Hi Guys,

I have a small challenge with Macro recording. I have a big table with few conditional formatting rules. I Macro recorded copying the table to new sheet with transpose and few cosmetic changes - all works. However, when I run Macro the table is copied with all the conditional formatting. In order for the conditional formatting to work the formula need to refer to the initial sheet I copied the table from.
I adjusted the conditional formatting but Macros doesn't record it and when I run it will not change the formula of the conditional formatting. Any thoughts or suggestions?

Thanks

**wakeupcall** · 11-22-2013, 01:32 PM

That is perhaps because the conditional formatting has already been applied to your table

If not too complex, try clearing it and then start recording by re-applying it again and then copy your table.
This will give you the syntax of the conditional formatting, which you can then tweak in your code to refer to the original table and re-apply on the 2nd

**skalus** · 11-24-2013, 02:29 PM

thanks for the tip. I will try it and let you know the results.

**skalus** · 11-25-2013, 08:38 AM

training plan trial.xlsm
Hi Guys,

I tried to do a conditional formating whilst recording but Macros recording doesn't pick up any activity. I attached a file which I am working on, so you can see what I want to do.

I will appreciate any thoughts.

Thanks