Reapply conditional formatting rule when sheet is available

[Samadhan Gaikwad]

Hi,

I have formula in conditional formatting

=$F1="Files are on EMEA server"

which applies formatting in

=$F:$G

column to change font color. When macro runs, it deletes sheet1 where this rule was applied but after that macro creates same sheet1 again. So is there way to reapply this rule for sheet.

 

[Mike86]

Try recording a macro while you go through the entire process from scratch. Include generating the conditional formatting.

 

[Samadhan Gaikwad]

Thanks! I was also thinking of that way only. But was wandering if there is other way to save conditional formatting rule.