Conditional Formatting confusion - Excel 2003

[Ann Scharpf]

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)

 

[Dave Peterson]

Does value mean number or just any old entry?

If number:
=count(w4,af4)>0
to see if either or both have a number

=count(w4,af4)=1
exactly one have a number

=count(w4,af4)=2
both have numbers

Use
=counta()
to count any entry--numbers, text, even formulas that evaluate to "".

 

[Gord Dibben]

Select the cell to CF

Formula is: =COUNT(W4,AF4)>0

If values could be non-numeric use COUNTA


Gord Dibben MS Excel MVP

 

[Ann Scharpf]

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