View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default if and conditional format

Can you use the condition that makes a1 go red?

for instance you enter in a3 ..........
=if(a1<0,a1,a2)


--
Greetings from New Zealand

"RayNDM83" wrote in message
...
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