Hi all, I'm wondering if any of you can help me with some conditional formatting logic. 

It should be quite simple: I want to create a conditional formatting rule that only changes the font colour and not the fill. The reason is because I already have certain fill colours for the subtotals in my table (i.e.: margin, ebitda, etc.) and I don't want to override the fill colour for these subtotals. So my conditional formatting should only change the font colour instead. 

Is there any way to do this? I’ve tried using the ‘transparent’ fill colour, but that doesn't help.

Any help is much appreciated!