Conditional Formatting based on Text

I used this formula in a conditional formatting to highlight/shade a row based on whether column G was greater than or less than 20:

=ABS(N($G25))>=20

I want to do the same thing but instead of a number I want to say if column G contains a certain text instead.

For example if G contains the text "LOA" than the formula would be true.

Thanks for any help.

Select Column G

Conditional Formatting > Highlight Cell Rules.....

Format only cells that contain >

Cell Value > equal to >

Please Login or Register  to view this content.

Hope this helps