I\'m trying to apply a conditional format where I want to change the font only (
ID: 3562111 • Letter: I
Question
I'm trying to apply a conditional format where I want to change the font only (italic) if the rule is met. Excel keeps changing the fill color and I can't make it stop. I previously applied manual colors as a visual "grouping" aid but the conditional format keeps overwriting those colors with a fill color. In the fill dialog box there is no option for no fill. There is a clear button in the lower right but that appears to just reset it to the default. There is a "No Fill" option that when selected become "No Color" which overwrites the manual fill to white.
I've been ussing Excel on Windows foreverr and consideer myself an expert. Bought a Mac and this version is kicking my ...
WHen criticcal, I've had to open the file in Windows, fix it, then re-open it in OS X and it works fine so long as I don't edit itt.
Explanation / Answer
I think the reason you get the result you want in Excel for Windows is that the Windows version is not properly maintaining the background setting. In other words, you