Conditional Formatting based on Max Length from Cell Value

[jeff_cp]

I have a max length value in cell B12 set to 4 and my text to conditional starts in field B14. I'd like the conditional formatting to highlight any cells where the length is greater than the value of cell B12. I tried =LEN(B14)>B12 but it didn't work while =LEN(B14)>4 does work.

 

[Fluff]

I tried =LEN(B14)>B12 but it didn't work

In what way didn't it work?

 

[jeff_cp]

In what way didn't it work?

The length of B15 = 5 so that cell should have been filled with red based on my conditional formatting.

 

[DanteAmor]

You must set the row and also preferably the column with the $ sign

=LEN(B14)>$B$12

 

[Joe4]

The length of B15 = 5 so that cell should have been filled with red based on my conditional formatting.

Your formula is supposedly checking cell B14, not B15.
If you are looking to apply this to multiple cells, perhaps you need to lock the B12 reference, i.e.

=LEN(B14)>$B$12

 

[jeff_cp]

Yep thanks!

 

[DanteAmor]

All happy to help you. Thanks for the feedback.