Any text or number and the cell will be colored from conditional formatting

[chaiyya345]

Hi All,

What i have been doing is just ISBLANK from the conditional formatting with no format & manually colored the cell. But what im trying to achieve is making the cell colored for any text/numbers being entered, but no luck. i guess, by using wildcards?

Any help is greatly appreciated.

Please find attachment.

Thank-You very much

[Rick Rothstein]

Try using LEN>0 since any cell with text or numbers will have a length of one or more whereas blank cells will have length zero.

[chaiyya345]

Hi Rick,

You mean, =LEN(A2>0) from the conditional formatting? it doesnt work

Thank-You very much

[Rick Rothstein]

You have your parentheses wrong. As you wrote it, you are getting the length of either TRUE or FALSE depending on whether the value in cell A2 is greater than zero or not. This is how you should write it...

=LEN(A2)>0

This way, you are getting the length of whatever is in cell A2 and seeing if that length is greater than zero or not.

[chaiyya345]

Ooop...my bad

yes, it works!
Will mark this thread to Solved & added reputation to you.

Thank-You very much