Just had some good help off ETAF, but would like to know where i'm going wrong with this one.
I had this Conditional format formula which works:
But now would like to add to this, I cant make another format, as this would be a fourth (I can only use 3)
As well as the formula, I would like to add in there also if D9 contains the text "Not Done".
Tried this But cell goes clear when the text "Not Done" appears.
Bearing in Mind that the cell that contains the text "Not Done" is produced from a formula, not physically typed in, whether this makes a difference?
Many Thanks.
Bookmarks