Characters In Cell Formula

  steviegee 12:39 25 Jun 2010

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 2010

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


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

  VoG II 12:43 25 Jun 2010

Sorry, 27 not 20 in the formula.

  steviegee 13:10 25 Jun 2010

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

  VoG II 13:25 25 Jun 2010

I've uploaded a small demonstration click here

  steviegee 13:48 25 Jun 2010

Sorry that does not help.

  VoG II 13:54 25 Jun 2010

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 2010

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.


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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?