How to do conditional format depending on another cell value?

[MGadAllah]

Hi
I've two cells, each one in a single separate column.
I want to do a conditional format in a cell of them but I want it to depend on the value exists in the other cell value.
Ex.
Cell A1 = GO
Cell B1 = $500
I want to do a conditional formatting for cell B1, and I want it to only happen and apply only in case the cell A1 contains the letter "O", and I want conditional format for cell B1 to be changing cell's font color to RED, so the final result will be changing the font color for cell B1 to red in case cell A1 value contains the letter "O".
So how can I do so?

[:) Sixthsense :)]

In B1 CF formula

=ISNUMBER(SEARCH("o",A1))


Refer the attached file

If the O is case sensitive then change SEARCH to FIND

[MGadAllah]

In B1 CF formula

=ISNUMBER(SEARCH("o",A1))


Refer the attached file

If the O is case sensitive then change SEARCH to FIND

Exactly

[MGadAllah]

Hi
Please if the cell is not A1 and I want to apply it for the whole column?
Ex.
Please check sheet 2 in the attached document.
CF Color Change.xlsb