Hello. Can you use conditional formatting based on the number of characters in a cell? I have line items in column 1. If the number of characters is less than 10 I want to color that row for the first four columns the same color (grey). Can I do this?
I think I could do conditional formatting. Would this formula work: AND(LEN(A29:A400,10)....SAME range not equal to "" (for blank rows)?
Thanks
Last edited by amartino44; 10-11-2013 at 12:55 PM.
The rule would look like this, for "Use a formula to determine which cells to format" and would apply to the range $A:$D
Formula:
Please Login or Register to view this content.
Sweet. I think that is going to work. The only problem is that A1 is a formula so Len isn't working on it. This is an example of a line item 601100 601100 5008 ACCRUED PTO but the content in the cell is a lookup formula. WHat should I do?
I think I answered something similar in your other thread?
CF doesnt look at the formula in a cell (no regular formula does), rather it sees the answer to that formula. So if the answer is <10, the formula will see that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks