• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Status Color

Status
Not open for further replies.
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
 

Attachments

  • Color Name.xlsx
    8.1 KB · Views: 8
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,
 
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.
 
Status
Not open for further replies.
Back
Top