strings....

[MR3]

i am trying to do a conditional format in my script which will fill the cell in red, if its length of the string contained in that cell is > 6 characters. The problem that I am having is that I cannot figure out how to make it loop through all of the rows with data in them.

=len(A1) > 6

 

[villy]

Highlight the columns you would like your conditional formatting to be with then apply the conditional format. It will automatically be applied in all rows met the criteria

 

[MR3]

i tried to record a macro and do it that way... it doesnt seem to work. possibly because the column already contains conditional formatting.

 

[villy]

Yes it might cause the problem because if you have already CF it will conflict your macro if both criteria doesn't agree.