Forum Discussion

Copper Contributor

Sep 27, 2025

Solved

Conditional Formatting (?) Issue

I'm trying to change the colour of the font in a cell based on the value in an adjacent cell but can't get the formula to work. Help please! Example: Cell A Cell B ABC xxxxxx DEF ...

excel

Formulas and Functions

JWB48
Sep 30, 2025
Perfect - thank you so much

Harun24HR

Bronze Contributor

Sep 30, 2025

Try these rules in CF.

=$A1="ABC"  //For red
=$A1="DEF"  //For green
=$A1="GHI"  //For blue

conditional_formatting.xlsx9 KB

JWB48
Copper Contributor
Sep 30, 2025
Perfect - thank you so much
- Harun24HR
  Bronze Contributor
  Oct 01, 2025
  Glad to know! You should mark as solution to my answer not your one. That is how this community works and visitors can know that it helps to solve your problem.