-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to highlight a cell that contains more than 50 characters using conditional formatting?
- Thread starter rajtak
- Start date
The formula will work
When you apply it
- select your range from the top left cell and move down and accross as need
- use a new rule based on a formula
- use = LEN(A1)>50 where A1 is the same cell address as your top left cell in the range to be formatted (ie it may be C1, A28 etc in your actual example)
Cheers
Dave
When you apply it
- select your range from the top left cell and move down and accross as need
- use a new rule based on a formula
- use = LEN(A1)>50 where A1 is the same cell address as your top left cell in the range to be formatted (ie it may be C1, A28 etc in your actual example)
Cheers
Dave
Upvote
0
Similar threads
- Solved
