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
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