Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating Doesn't Work! | Excel Discussion (Misc queries) | |||
How can I use conditional formating between two sheets in one work | New Users to Excel | |||
Conditional Formating won't work | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Custom formating won't work | Excel Worksheet Functions |