C
Cats
Hi all
A customer is using Excel to define data which will later be mangled
into a database, but they have a habit of putting in strings that are
too long. I'd like to be able to format a range of cells so that if
(e.g.) the length of the text is greater than 8 it is coloured red (or
whatever). So, 'abcdefgh' would be OK and normal but 'abcdefghi'
wouldn't be and would be highlighted in some way.
The conditional formatting help wasn't helpful.
This is Excel 2007 / Excel 2010.
TIA
A customer is using Excel to define data which will later be mangled
into a database, but they have a habit of putting in strings that are
too long. I'd like to be able to format a range of cells so that if
(e.g.) the length of the text is greater than 8 it is coloured red (or
whatever). So, 'abcdefgh' would be OK and normal but 'abcdefghi'
wouldn't be and would be highlighted in some way.
The conditional formatting help wasn't helpful.
This is Excel 2007 / Excel 2010.
TIA