In your first example, put a formula in B2 to test the value in A1.
In your second example, you could use a simple event macro to dynamically
test the value in D1 and set the appropriate cell in column A
--
Gary''s Student - gsnu201001


"Jim" wrote:

I'm using excel 2007.

I'm looking to have a logical test in one cell that will populate a
different cell if true, or a third cell if false.

For example, the logical test located in cell A1: If (A2=3, then Cell B2 =
"True", then Cell B2="RED")

Another variation is to have the value in a cell determine the new cell
location. For example, IF(D1="","", then cell A(Row Number D1)="Populated")


Solutions?