I know OpenOffice can do it but I can't seem to figure out if Excel can or not.
I have various styles defined to include the font, color, pattern, etc. which are setup the way that I want. I also have conditional formatting formulas set where I want. All appears to be working well.
What I want is that the result of the conditional format uses the style reference rather than the absolute reference by changing the format in the conditional dialogue box. Can Excel handle that? If so, how?