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