Format (excel 2002)

  • Thread starter Thread starter p1enguin
  • Start date Start date
P

p1enguin

cell A1=Jim (green)
cell A2=Bob (blue)
cell A3=Jill (red)

In cell D10 Ihave: IF(B2>5,A1,A3)

How do I get the original format (Color) of A1, A2 or A3 in D10 ??

Thanks.
 
Formulas return values--not formatting.

You might be able to use the same Format|conditional Formatting for both the
"sending" and "receiving" cells.

(or some kind of worksheet event macro)
 
Try this (Conditional Formatting):

Select D10

Click Format > Conditional Formatting

For Condition 1, make the settings as:
Formula Is | =$D$10=$A$1
Click Format button > Patterns tab > Select Green > OK

Click Add >>

For Condition 2, make the settings as:
Formula Is | =$D$10=$A$3
Click Format button > Patterns tab > Select Red > OK

Click OK at the main dialog

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------
cell A1=Jim (green)
cell A2=Bob (blue)
cell A3=Jill (red)

In cell D10 Ihave: IF(B2>5,A1,A3)

How do I get the original format (Color) of A1, A2 or A3 in D10 ??

Thanks.
 
Back
Top