I\'m trying to apply a conditional format where I want to change the font only (

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

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.