How do i word this formula?

Question

I am trying to get the following where the criteria is&nbsp;"Green" and/or "Red".&nbsp;I am wanting to know the statement of formula for if either or both Columns A &amp; B contain&nbsp;"Green" or "Red". If&nbsp;"Green" and/or "Red" are&nbsp; in Columns A &amp; B then Column C will return "Traffic Light Colour". If neither Column A or B have these colours then it will need to return a blank cell.&nbsp;Below is the outcome I am after.&nbsp;&nbsp;Column A&nbsp; Column B&nbsp; &nbsp;Column CBlue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Traffic Light ColourRed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Traffic Light ColourRed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Traffic Light ColourRed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green&nbsp; &nbsp; &nbsp; &nbsp;Traffic Light ColourPurple&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Blank Cell)Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;(Blank Cell)Green&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Traffic Light ColourPurple&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;(Blank Cell)Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Purple&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;(Blank Cell)Blue&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green&nbsp; &nbsp; &nbsp; &nbsp; Traffic Light Colour&nbsp;Any help please?

oliverscheurich · Answer

alexw94&nbsp;=IF(OR(COUNTIF(A2:B2,"Red")&gt;=1,COUNTIF(A2:B2,"Green")&gt;=1),"Traffic Light Colour","")You can try this formula.

alexw94 · Answer

OliverScheurich&nbsp;Many thanks, thats worked for 2, however my requirement has changed. I now need it to be searching for 3 colours rather than 2. Lets say the third colour is "Blue", how would I change that formula you have made to search for blue as well as Red and Green?

oliverscheurich · Answer

alexw94&nbsp;=IF(OR(COUNTIF(A2:B2,"Red")&gt;=1,COUNTIF(A2:B2,"Green")&gt;=1,COUNTIF(A2:B2,"Blue")&gt;=1),"Traffic Light Colour","")You are welcome. Is this what you are looking for according to the changed requirement?&nbsp;

Forum Discussion

How do i word this formula?

3 Replies

Resources