Conditional Format Question

[Guest]

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

 

[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

 

[Don Guillett]

format>conditional format>formula is
=b2=2
format as desired

 

[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