Conditional Formatting confusion - Excel 2003
 

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

Conditional Formatting confusion - Excel 2003
 

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 "".



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)

--
Ann Scharpf

--

Dave Peterson

Conditional Formatting confusion - Excel 2003
 

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)

Conditional Formatting confusion - Excel 2003
 

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)

.