change color if character length greater than 2

[#1]

Hello,

I want to make anything thats longer than 2 letters/numbers appear green in my table i have.  How would i go about doing this?

if (Date1 ????(), green(), red())

Thanks

[#2 · Accepted solution]

Hi Brandon,

use len to check the length of the value

if(Len(Date1)>2,green(),red())

hope that helps

Joe

[rustyfishbones]

You can try

IF(LEN(Date1) > 2, RGB(0,170,0), RGB(170,0,0))