I'd like to create a conditional formatting calculation that is if a field is not empty, it gets colored red. How would i do the calculation?

I'd like to create a conditional formatting calculation that is if a field is not empty, it gets colored red. How would i do the calculation?

- 4 people found this helpful
I commented on "even simply" part of the post. First part

not IsEmpty ( self )

would work well on OP's requirement.

Your suggestion also would work but for limited case, and the logic looks inverted. OP need condition for "not empty". Yours may be used in "empty or 0 (or negative)". If so, <=0 could be better than < .01. The number .01 arize question why isn't it .1 nor .001 etc.

Try

not IsEmpty ( self )

For a number field you could even simply use

self