Formula used to conditional format rule

[MrPink1986]

Hi there,

I am looking to incorporate the below rule as a conditional format rule - use a formula to determine which cells to format.

=IF(M2="","",IF(LEN(M2)>12,"Issue","OK"))

Do I need to create two rules essentially to replicate this here?
Or how do I amend this rule to "Format values where this formula is true:"?

 

[tyija1995]

I don't think you can use an IF statement in that way?

What exactly are you trying to achieve? I can't quite get my head around it!

 

[MrPink1986]

I don't think you can use an IF statement in that way?

What exactly are you trying to achieve? I can't quite get my head around it!

Good point I should have outlined this - In Column M for Cell2 I want to apply some conditional formatting that will highlight cells that have a string length greater than 12.
I am not concerned if the cell is blank and do not want any change made to these cells.

 

[Fluff]

Use
=len(M2)>12

 

[MrPink1986]

Simples ..... when you know how, thanks a bunch

 

[Fluff]

You're welcome & thanks for the feedback