conditional formatting
In message , Bernie Deitrick
writes
Thanks.
I will go and try this.
Thanks again.
This question appears as unanswered in my OE, so excuse me if this is
an extra, unneeded reply.
Select B1, then use CFR with the Custom option, with a formula that
returns TRUE or FALSE
IF A1 will just contain the exact word:
=A1="Done"
If it will contain a string that will have the word 'done'
=NOT(ISERROR(FIND("done",LOWER(A1))))
Of course, you might need further checks to differentiate between
"I'm done with this"
and
"I'm not done with this"
--
Nospam
|