oh, i've never used conditional formatting. i thought it was like a formula. i've never written a macro, but you could give that a shot. or try exporting it to xml, see how the conditional formatting is written, and if it's straight forward enough just do find/replace or write a script to generate it. i'm more into sql than excel

This post was edited by carteblanche on Jul 4 2013 07:17pm

Let me know if you come across a solution.
I'm genuinely interested at this point!

I don't really know how to program, but I'll keep fiddling I suppose.

meh

This post was edited by Simens on Jul 12 2013 05:36pm

pm me if you still need a solution for this.

Sent you a pm.

If you still need this, send me a pm with the EXACT specifications. I can write this as custom formulas or using a macro. We can discuss which would be best for what you want to do.

This post was edited by Segfault on Aug 30 2013 02:53pm