Logical And Save Data

[Yanto hendrawan]

To all members, Merry chrismast.....

Thank to Roger Govier.

Help me more....

1. How to make formula if in cell B2 contain text "open", c2 will show
text "Red" and if B2 contain text except "open" c2 will show text
"Green", And if B2 contain text except "open" and in D2 any number,
C2 will show text "Red"?

2. If I type data in cell b2,b3,and b4, i want to save them to sheet2
in cell b2, b3, and b4 and c2, c3 and c4 and more... Finally, it will
make a table of data. using macro?

Thanks a lot.

Regards,

YH

 

[Max]

1. How to make formula if in cell B2 contain text "open", c2 will show
text "Red" and if B2 contain text except "open" c2 will show text
"Green", And if B2 contain text except "open" and in D2 any number,
C2 will show text "Red"?

Perhaps in say, E2:
=IF(B2="","",IF(B2="Open","Red",IF(ISNUMBER(D2),"Red","Green")))