Never mind, I finally got it to work. In case anyone may need to do the same
thing, here is how it was done.

Condition 1 = formula is =AND(istext($g$37),NOT(istext($G$38)))
Condition 2 = cell value is not equal to =ISTEXT($G$37)*ISTEXT(($G$38))



"JMB" wrote:

Maybe absolute reference instead of relative reference?
=istext($G$38)

Also, the 2nd and 3rd condition could both be true at the same time. On my
machine, if both were true it formatted according to the second condition.


"Jan" wrote:

I am using Excel 2003. I have the following conditions, but can not get the
result I want for Condition 3. I have tried various ways without success.
Maybe what I am trying to do is not possible, but if it is can be done can
someone help?

Condition 1: cell value is equal to =$G$37 - no format set
Condition 2: formula is =istext($G$37) - format set to color cell yellow
with bottom cell underlined (this works)
Condition 3: formula is =not(isnumber(G38)) - I want no cell color
underline if text is entered in cell g38. I believe this event won't occur
until the cell is exited.

TIA