Forum Discussion
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 example, if the text in my B column is 'Audiobook,' then I want the font in columns C, D, E, and F to be blue. If the text in the B column is 'Physical,' then I want the font in columns C, D, E, and F to be purple.
sierrahunt61 You need conditional formatting custom rule. Use below rules-
For blue font try-
=$A1="Audiobook"For Purple try-
=$A1="Physical"
