Conditional Formatting on a cell that has an IF function

Jon, assume SheetB!C4="Y" is your true condition and SheetB!C4="N" is your
false one. Since the cell is located on a different worksheet, you won't be
able to refer to it by its address; you'll have to define a name for it
(select the cell and Insert Name Define; enter a name; OK). I'll call
SheetB!C4 "flag1." C5 can be flag2.

In SheetA!B4, do the conditional formatting (Format Conditional
Formatting) as follows:

Condition 1: Formula is: =flag1="Y". Format Patterns [green] OK
Condition 2: Formula is: =flag1="N". Format Patterns [red] OK

Repeat for SheetA!B5, substituting flag2 for flag1.
--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Jon W" wrote in message
...
I have a column of data that pulls data from two sheets based off of a
flag

SheetA.Cell(B4) =IF(SheetB!C4 = "Y", SheetB!B4, SheetC!B4)
SheetA.Cell(B5) =IF(SheetB!C5 = "Y", SheetB!B5, SheetC!B5)
....

I would like to add conditional formatting to the SheetA cells to show
green with a true condition and red with a false conditon.

Thanks.