Consulting

Results 1 to 2 of 2

Thread: Check string length

  1. #1
    VBAX Contributor
    Joined
    Jun 2014
    Posts
    114
    Location

    Check string length

    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



    I would like have this result




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


  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    cross posted without links

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •