Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Brandon,
use len to check the length of the value
if(Len(Date1)>2,green(),red())
hope that helps
Joe
Hi Brandon,
use len to check the length of the value
if(Len(Date1)>2,green(),red())
hope that helps
Joe
You can try
IF(LEN(Date1) > 2, RGB(0,170,0), RGB(170,0,0))