Conditional Formating Doesn't Work
 

Can't figure out why this doesn't work!

In Cell R650 a value dollar format $15,865.63
In Cell K650 =SUM(J636:J650) showing a total of $18,086.12

Rule 1: if cell value = 0 no color
Rule 2: if cell value = $K$650

I tried different formats for number (general, comma, etc.)
I tried changing the sum to a value

I'm on Excel 2002 with SP3

What gives???

PS. I hit enter accidently on an earlier post... sorry

Conditional Formating Doesn't Work
 

It still might be a round off issue
in an empty cell enter =(your cell)=k650
if the answer is false, you will probably need to work with rounding

" wrote:

Can't figure out why this doesn't work!

In Cell R650 a value dollar format $15,865.63
In Cell K650 =SUM(J636:J650) showing a total of $18,086.12

Rule 1: if cell value = 0 no color
Rule 2: if cell value = $K$650

I tried different formats for number (general, comma, etc.)
I tried changing the sum to a value

I'm on Excel 2002 with SP3

What gives???

PS. I hit enter accidently on an earlier post... sorry

Conditional Formating Doesn't Work
 

Which cell are you selecting as your CF cell?

R650?

Rule 1 : cell value is: 0 no color

Rule 2 : formula is: =$K$650 color is Red


Gord Dibben MS Excel MVP

On 20 Mar 2007 09:02:58 -0700, wrote:

Can't figure out why this doesn't work!

In Cell R650 a value dollar format $15,865.63
In Cell K650 =SUM(J636:J650) showing a total of $18,086.12

Rule 1: if cell value = 0 no color
Rule 2: if cell value = $K$650

I tried different formats for number (general, comma, etc.)
I tried changing the sum to a value

I'm on Excel 2002 with SP3

What gives???

PS. I hit enter accidently on an earlier post... sorry