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)

--
Ann Scharpf