Conditional formatting a cell on another cells output, which is a formula

[HankJ]

Hello

I would like to format a cell, with warning colours, when another cell displays " Unusual pattern on plate 8. Please Check"

The formula is the active cell is:

=IF(AND(BX207<400,N17<>"")," Unusual pattern on plate 8. Please Check","")

In N17 I would to format the text Bold Red if " Unusual pattern on plate 8. Please Check" appears in O29.

My attempt:
="O29= Unusual pattern on plate 8. Please Check"

as a formula does not appear to work.

Many thanks

Hankj

 

[63falcondude]

Did you try moving your quotes to this =O29=" Unusual pattern on plate 8. Please Check"

Also, you know that there is a space before Unusual right?

 

[HankJ]

Hi 63Falcondude
It worked a treat
Many thanks
Hankj

 

[63falcondude]

Hi 63Falcondude
It worked a treat
Many thanks
Hankj

Glad to help. Thanks for coming back to respond.