On Jun 24, 10:05 am, Belinda7237
wrote:
In column U i have cleared or its blank
so i replaced your not cleared with <cleared in the formula

Which did you put in:

<cleared
<"cleared"

You need the quotes to identify text. Seems to work for me with a
quick test.