formula issue?

[RUSSELLCLEWS]

Hi there. Please can anyone help? Im trying to display the work "Blue" in a cell if two other cells say the word "Standard" I have this formula but cant seem to get it right?

=IF((AND(ISNUMBER('SEARCH'("BLUE",H8 "BLUE",I8)),"STANDARD","")

Can anyone correct me on this?

Thanks in advance..

 

[jasonb75]

Must be array confirmed with Ctrl Shift Enter if you are using anything other than office 365 / excel 2022.

=IF(AND(ISNUMBER('SEARCH'("BLUE",H8:I8))),"STANDARD","")

 

[RUSSELLCLEWS]

Must be array confirmed with Ctrl Shift Enter if you are using anything other than office 365 / excel 2022.

=IF(AND(ISNUMBER('SEARCH'("BLUE",H8:I8))),"STANDARD","")

Thanks for the replay Jason but it doesnt seem to work. when I put the formula in, it doesnt highlight the cells or display anything after. I use the following forumla for single cells and this works:

=IF(ISNUMBER(SEARCH("BLUE",D8)),"STANDARD","")

How can I select two cells with this formula?

 

[mohadin]

Hi
Try

=IF(AND(ISNUMBER(SEARCH("BLUE",H8)),ISNUMBER(SEARCH("BLUE",I8))),"STANDARD","")

 

[RUSSELLCLEWS]

Hi
Try

=IF(AND(ISNUMBER(SEARCH("BLUE",H8)),ISNUMBER(SEARCH("BLUE",I8))),"STANDARD","")

GREAT! IT WORKS, THANK YOU JASON.

 

[mohadin]

 

[DanteAmor]

How about:

=IF(ISNUMBER(SEARCH("*BLUE*|*BLUE*",H8&"|"&I8)),"STANDARD","")

 

[jasonb75]

GREAT! IT WORKS, THANK YOU JASON.

I didn't post that reply, someone else did.

The formula that I posted does work, when I copied yours from post 1 to save typing I missed that you had some single inverted commas that don't belong in the formula which would be the reason for it not working.

=IF(AND(ISNUMBER(SEARCH("BLUE",H8:I8))),"STANDARD","")

Friendly tip, leave the caps lock off when you type your replies

 

[RUSSELLCLEWS]

Thank you!!!

 

[RUSSELLCLEWS]

Hi
Try

=IF(AND(ISNUMBER(SEARCH("BLUE",H8)),ISNUMBER(SEARCH("BLUE",I8))),"STANDARD","")

Hi Mohadin,

Please can you help with one more? Im trying to format a cell, for example

Cell A1 says: Ohlins" in the cell. I want writting in B1 to change colour to white. What rule can I use in conditional formatting?