Status Color

[Umesh Chahar]

Hello all,
I need help of all you guys, i have two columns , column A and column B . Column A has some text along with color name, Namely Green, Orange and Amber like "Supplementary Green, Complementary Orange etc. Now what i want in column B, those rows which have text along with color Name Amber and Orange as "Non Green" and which have text along with Green should come as "Green".

For eg.

BGC Status Color Coding
Supplementery Green Green
Umesh Amber Non Green
Riya Orange Non Green
Complementery Green
Umesh Orange
Riya Green
Riya Amber
Supplementery Orange
Complementery Orange.

Please see the attached File

 

[Marc L]

Hi !

At beginner level, B2 formula :
=IF(ISERR(SEARCH("Green",A2)),"Non green","Green")
Copy down …
​

 

[Umesh Chahar]

thank you so much its working thanks a lot

 

[Khalid NGO]

Hi to all,

Another option can be used with COUNTIF + cell formatting:

=COUNTIF(A2,"*green*")
Format the cell as:
"Green";;"Non Green"

Similarly with TEXT function without changing cell formats:
=TEXT(COUNTIF(A2,"*green*"),"""Green "";;""Non Green """)

Regards,

 

[SharadSalvi]

Hi all
I am new member here
I want to countif cells A1:G16 having cell color $K$1

 

[Luke M]

Hi @SharadSalvi

Welcome to our forum. However, you'll get more help if you start your own thread, rather than tacking on to someone else's previously solved thread.