Hi

The problem I am trying to address is that on my Sheet 1 I want to create a
template for uploading catalogue data. As such the fields have to be of
defined length or default entries. I am pasting the raw supplier data in
Sheet 2 and pulling it through into the template.

Descriptions are limited to 40 characters so I have set an IF formula to
strip out the first 40 if the raw data is longer or return the raw data if
less. However, I want to highlight that the description has been truncated
and therefore the user should check how meaningful it is and overtype if
necessary.

Where the text has been truncated, I tried to flag it with a conditional
format checking if the length of the entry on Sheet 2 is 40 but it says it
cannot do this. Because the template has to be in a set format I do not want
to introduce additional columns for flags on Sheet 1. Is there a way to get
around conditional formatting from another sheet or is it possible to
identify that my IF statement has produced a TRUE or FALSE status?

As always I appreciate any help offered.

G