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