How do I identify the character count of specific cells - P2

Hi WaynePB!

To format cells that fall between two specific character lengths, you can use a formula with the "AND" function that checks if the length of the cell's content is greater than or equal to the minimum length and less than or equal to the maximum length. Here's how you can do it:

Select the cells you want to apply the formatting to. Go to the "Home" tab on the ribbon and click on "Conditional Formatting". Select "New Rule". Choose "Use a formula to determine which cells to format". In the "Format values where this formula is true" box, enter the following formula: =AND(LEN(A1)>=5,LEN(A1)<=10). Replace "A1" with the top-left cell in the selected range, "5" with your minimum character length, and "10" with your maximum character length. Click on the "Format" button and choose the formatting you want to apply to the cells that meet the criteria. For example, you could choose to fill the cells with a different color. Click "OK" to close the "Format Cells" dialog box. Click "OK" to close the "New Formatting Rule" dialog box. The above steps will highlight all cells in the selected range with a character count between 5 and 10. If you want to change the minimum and maximum character lengths, simply replace "5" and "10" with the desired values in the formula.

Alternatively, you can use VBA code: Sub HighlightCellsByLength() Dim minLen As Long Dim maxLen As Long Dim rng As Range Dim cell As Range

minLen = 5 ' Replace with your minimum character length maxLen = 10 ' Replace with your maximum character length Set rng = Selection ' Change the range to your desired range

For Each cell In rng If Len(cell. Value) >= minLen And Len(cell. Value) <= maxLen Then cell. Interior.Color = RGB(255, 255, 0) ' Change the color to your desired color End If Next cell End Sub

Replace the values for "minLen" and "maxLen" with your desired minimum and maximum character lengths. Change the "Set rng" line to select the range you want to apply the formatting to. Save the module. To run the code, go back to your worksheet and select the range you want to apply the formatting to. Press Alt + F8 to open the Macro dialog box. Select the "HighlightCellsByLength" macro and click "Run". The above VBA code will loop through all cells in the selected range and check if the length of the cell's content is greater than or equal to the minimum length and less than or equal to the maximum length. If the cell meets the criteria, the code will highlight the cell with the specified color.

Note that this code will only work for one selected range at a time. If you want to apply the formatting to multiple ranges, you'll need to run the macro for each range separately.

Best Regards, Shakiru