Characters In Cell Formula

  steviegee 12:39 25 Jun 10
Locked

Is there a formula/macro that will colour in any cell that has more than a specific number of characters in it. For example I want the cell coloured in red if it has more than 27 characters in it. Thanks. Info starts in column S and finishes in column CB

  VoG II 12:42 25 Jun 10

Select S1:CB100 (for example), Format > Conditional Formatting, select Formula Is, enter the formula

=LEN(S1)>20

then click the Format button, click the Fill tab, click on a colour, OK, OK.

  VoG II 12:43 25 Jun 10

Sorry, 27 not 20 in the formula.

  steviegee 13:10 25 Jun 10

That doesn't seem to do anything (there are about 5000 rows too)

  VoG II 13:25 25 Jun 10

I've uploaded a small demonstration click here

  steviegee 13:48 25 Jun 10

Sorry that does not help.

  VoG II 13:54 25 Jun 10

I don't know what else you expect me to do. It works for me as I've shown you.

  TonyV 19:23 25 Jun 10

To see what VoG™ is trying to tell you, Click on one of the coloured cells in his demo, then click on Format/Conditional Formatting and you will see how his formula is working. The cells become red when there are more than 27 characters. With set width of cells, all the characters will not necessarily show. See his cell x4.

Or are you trying to get the whole of the 27 characters to show in a red back ground? In which case the columns will have to be widened to accommodate that number.

TonyV

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

What I learned from my mentor, Oscar-winning VFX supervisor Phil Tippett

Siri vs Google Assistant