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 yyyyyy
GHI xxxxxx
If Cell A = ABC, I want Cell B to be Bold Red font
If Cell A = DEF, I want Cell B to be Bold, Blue font
If Cell A = GHI, I want cell B to be Bold Green fomnt
Thanks in advance.
2 Replies
Try these rules in CF.
=$A1="ABC" //For red =$A1="DEF" //For green =$A1="GHI" //For blueTake 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.
