Forum Discussion
sierrahunt61
Jan 03, 2023Copper Contributor
IF THEN FORMULAS
I need help figuring out how to write a formula that tells excel that if the content of a specific cell says a certain thing, the font colors in certain other cells will a certain color. So for exampl...
Harun24HR
Jan 03, 2023Bronze Contributor
sierrahunt61 You need conditional formatting custom rule. Use below rules-
For blue font try-
=$A1="Audiobook"For Purple try-
=$A1="Physical"