Is it possible to base conditional formatting on text length?
I want to highlight any cell in a column where there is an entry more than 3 characters long. The values entered into this column will always be one of the following layouts:
KD ie 2 letters
KNH ie 3 letters
KD/KNH (10%) ie a combination of 2 or 3 letters, followed by a forward slash, followed by 2 or 3 letters, followed by a percentage in brackets
Basically, the column will usually have 2 or 3 letters entered in each cell, but I want my attention to be drawn to a cell if there is going to be more than 3 characters in it.
There are currently 1 users browsing this thread. (0 members and 1 guests)