Hi guys,

I have an excel sheet that have a large set of datas. In these datas in one column most of the datas are indicated as green but some of them are red. I can pick the red ones by using filter option but I also wanted to show the red cell values in one cell. For example, Cell1;Cell2;Cell3 like this (the ; should be between them). I try to use macros but that is not the program that I have full knowledge about it. So i can not solve the issue.

How can I solve this?

Thanks

( Like this
IF
A(i)= red

Then
B(i)=A(i)
end if
)