Conditional Format Question

D

DougS

How can I conditionally format cell A1 when that conditional format is based
on another cells value? Example: I want to highlight A1 with Red when cell
B2= 2
 
G

Gord Dibben

Doug

Select A1 and Format>CF>Formula is:

=$B$2=2

Pick a nice red color from the Format>Patterns Tab and OK your way out.


Gord Dibben Excel MVP
 
S

Steve R

1) Click on A1
2) Open conditional formatting
3) Change the drop box from "Cell Value Is" to "Formula Is"
4) Enter "=B2=2" (without quotes) as the formula
5) Choose your format, pattern

HTH
Steve
 
Top