if and conditional format

  • Thread starter Thread starter RayNDM83
  • Start date Start date
R

RayNDM83

Hi,
Is it possible to create this statement in excel:
if a1 is color "red", then a3=a1, if not then a3=a2.
Thanks,
Ray
 
Can you use the condition that makes a1 go red?

for instance you enter in a3 ..........
=if(a1<0,a1,a2)
 
Hi Bill,
No, a user will highlight cell a1 or a2 for me and i need to pick the
hightlighted cell and copy it to a3.
Thank you for taking time on this.
Ray
 
Back
Top