Yes.

Select the cell with your formula and F2 then edit out the (OT) but leave "" to
return a blank if no data found.

You then would use FormatConditional FormattingCondition1Formula is:

=cellref="" Format to a color you like.


Gord Dibben MS Excel MVP

On Mon, 8 Jan 2007 15:59:00 -0800, Phazer
wrote:

I have a worksheet that someone else made and it has what I think is a
conditional formula
=IF(ISNA(VLOOKUP(B9,patrols1,3,FALSE)),"(OT)",(VL OOKUP(B9,patrols1,3,FALSE)))
can this be made to color the cell rather than display (OT)?