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

formatconditional formatformula is
=b2=2
format as desired

--
Don Guillett
SalesAid Software

"DougS" wrote in message
...
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

Doug

Select A1 and FormatCFFormula is:

=$B$2=2

Pick a nice red color from the FormatPatterns Tab and OK your way out.


Gord Dibben Excel MVP

On Mon, 2 May 2005 17:15:16 -0700, "DougS"
wrote:

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

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
"DougS" wrote in message
...
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