Highlighting a Cell based on Text

[Pippy79]

Hi

i wonder if this requires conditional formatting? but i want to highlight a cell a colour based on the characters is in the middle of the text.

the text could be - 0102ES12345 or 0102GB12345

i want to highlight the "ES" text cell one colour and leave the "GB" cells.

thanks

 

[Fluff]

You could use something like

=mid(A2,5,2)="ES"

in conditional formatting.

 

[gargamalebarbosa]

Hi ,

* Select data range

* Conditional Formatting / Highligth Cell Rules / Text That Contains / insert "ES"

 

[Legacy 143009]

Point to Highlight Cells Rules, and then click Text that Contains.

Do you need something different than this?

 

[gargamalebarbosa]

 

[Pippy79]

thanks, they all work.

 

[Fluff]

Glad we could help & thanks for the feedback.