Conditional formatting on cells with formula

[mikehk]

I want to format a cell if it has any text so I used
=ISTEXT('2018'!$E2)


everything was fine until I put a formula in cell 2018!$E2,
cell is empty but gets the rule from CF

How do I fix it?

[Phuocam]

Try:

=ISTEXT('2018'!$E2)*LEN('2018'!$E2)

[mikehk]

This works...thanks so much