Forum Discussion
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 ...
Take this:
Step 1: Select the Range
- Select the range in Column B where you want formatting (e.g., B1:B100).
Step 2: Open Conditional Formatting
- Go to Home > Conditional Formatting > New Rule
- Choose “Use a formula to determine which cells to format”
Step 3: Enter the Formula
For each rule, use a formula like this:
Red for ABC
=$A1="ABC"
Blue for DEF
=$A1="DEF"
Green for GHI
=$A1="GHI"
Make sure the $A1 reference is relative to the first row of your selection (e.g., B1).
Step 4: Set the Format
- Click Format
- Go to Font tab
- Choose Bold and the desired Color
- Click OK
Repeat this process for each condition.