Macro Formula Please

  steviegee 09:30 29 Jan 09
Locked

Is there a Macro I can run that will highlight every cell in a spreadsheet that has more than 27 characters in it please. Thanks.

  Simsy 10:59 29 Jan 09

it as a macro?

You could achieve this with conditional formatting, would that not work?

Regards,

Simsy

  steviegee 11:08 29 Jan 09

I think thats what I need. VoG normally sorts me out with a macro for similar things.

  VoG II 11:13 29 Jan 09

Select the whole range starting in A1. Format > Conditional Formatting, select Formula Is and enter

=LEN(A1)>27

click the Format button, apply a format and click OK.

  steviegee 11:47 29 Jan 09

That worked thanks. But how do you decide between when you use a macro or formatting?

  VoG II 13:01 29 Jan 09

Its normally better to use CF. However if you want to have more that 3 conditions and you are using Excel 2003 or earlier then you need a macro.

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

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017