How to do a conditional formatting based on an adjacent cell

C

Confused

I want to conditionally format a cell if a different cell has contains
certain data. I only know how to do this based on the selected cells
contents. Can anyone help?
 
K

Ken Wright

Format / CF / Change 'Cell Value is' to 'Formula is' and then use normal
formulas with cell references.
 
G

Gord Dibben

To CF A1 when B1 is equal to "confused".......

Select A1 then Format>CF>Formula is:

=B1="confused"

Pick a format and OK your way out.

Gord Dibben Excel MVP
 
Top