Change the value in the condition1 is to "formula is" from "cell value is"

Then try the following formula in the conditional format
=AND(b1<a1,LEN(a1)255)



"Hugh Murfitt" wrote:

I have used conditional formatting to highlight when text in two adjacent
cells differ. Simple. Therefore, when text in cell B1 differs from that in
A1, B1 goes green. UNLESS the text in A1 is longer than 255 characters. How
can I get round this?