Excel help (Mac)

[mattfca]

So Excel on Mac

I have tabulated ads in rows, and I want to check if the length of a cell is greater than 25chars for headline and 35 for L1 and L2

Im using mac so VB doesn't work.

How can I set a column to check its cells char length and change the background color if its greater than a certain number?

=LEN(?)>25
in conditional formating for the column, but i have no idea what to use to get the cell

 

[kblessinggr]

I thought formulas worked the same on Office:Mac as they do on Window's excel. Have you tried looking for a formula option itself?


Sorry if that wasn't much help, but I use iWorks on a mac as opposed to office, much faster, but I don't think Numbers would compare well to Excel in terms of formulas and so forth.

 

[mattfca]

Well, mac doesnt support VB macros.

I can make it work on a single cell, but i dont want to repeat the formula and change the cell on each one.

So basically i can set a conditional format formula on the row =LEN(?)>25
but i dont know what to put to replace ? to get the active cell

 

[mattfca]

It can be done with applescript, i just dont know how to code applescript. Guess i'll have to learn