How to convert conditional formatting into true color using VBA?

If your Office version is actually later than the 2007 in your profile, you could also use Fluff's method.

Oops, never thought of that