Forum Discussion
How do i word this formula?
I am trying to get the following where the criteria is "Green" and/or "Red". I am wanting to know the statement of formula for if either or both Columns A & B contain "Green" or "Red". If "Green"...
OliverScheurich 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?
=IF(OR(COUNTIF(A2:B2,"Red")>=1,COUNTIF(A2:B2,"Green")>=1,COUNTIF(A2:B2,"Blue")>=1),"Traffic Light Colour","")You are welcome. Is this what you are looking for according to the changed requirement?