PDA

View Full Version : [SOLVED] Check string length



elmnas
08-11-2015, 04:49 AM
Hello people,

I have coded some but I am a still newbie and I have less time from my boss haha.


I got a excel file with many columns

there is a value in column "D " that presents max characters that is allowed for a cell.

I need to check all cells in column K to V and if there is more than the value it says in D Highlight same row and each cell highlight the cell with color red otherwise if its less highlight the cell with green

see picture

http://i.imgur.com/vhOwcHb.png

I would like have this result

http://i.imgur.com/we4Rqgr.png


Could someone help me with a code?
Thank you in advanc

p45cal
08-11-2015, 06:16 AM
cross posted without links