Thanks! That worked beautifully. I never would have thought of using the
COUNT() function.
--
Ann Scharpf


"Gord Dibben" wrote:

Select the cell to CF

Formula is: =COUNT(W4,AF4)0

If values could be non-numeric use COUNTA


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 11:02:06 -0700, Ann Scharpf
wrote:

I am trying to apply a conditional format to a cell when either/both of two
other cells on the row contain a value. I have tried every permutation I can
think of but nothing is working. I'm pasting a couple of variants of what
I've tried. (I also tried zero in the place of the one.)

Can anyone advise what I am doing wrong? Thanks!

=((W4+AF4)1)
=((W4+AF4)"1")

=IF((W4+AF4)1,TRUE,FALSE)
=IF((W4+AF4)"1",TRUE,FALSE)

.