the CF Conditions a

Cell Value is: Equal to =c13 - format is green and bold
Cell Value is: Greater than =C13 - format is red
Cell Value is: Less than: =C13 - format is Red and Bold

The conditional formatting is in place in cells in Column D starting with
row 13

The column/cells involved in the spread sheet where the data is entered a

Column C Column D
Target Actual
Row13 67 62

The data in column C is a calulation of minutes worked divided by cycle time
which give us a target procution number that appears in column C (in this
sample - 67)

In column D we enter the actual production number is entered (in the sample
- 62)

What should happen is -- if the number entered into D13 is 67 it should be
green and bold, if the number is another number other than exactily the same
number as c13 (67), it should be red.

Currently when I enter the data in D13 - if I enter 67 in that cell, it
comes shows in red (it should be green)
The same conditons/formulas exist in all other cells in column C and D --
the only cell that I have had this issue with is D13


"David Biddulph" wrote:

Copy from your CF conditions and paste the formulae here so that we can see
exactly what formulae you are using, then tell us what values are in the
cells to which those formulae refer, what formatting it gave, and what you
expected. We can then give you some hints as to what formulae you can put
in some helper cells to diagnose your problem.
--
David Biddulph

"debra49424" wrote in message
...
I have conditional formatting on a set of cells with 3 conditions.
If number in cell A3 is equal to number entered in cell B 3 it Green and
Bold
if the number in cell B 3 is less than A3 it is red
If the number in cell B3 is greater than A3 it is red and Bold

The conditional formatting works in all by one cell and for some reason no
matter what number is in the cell it does not accept the formatting- I
have
tried pulling the conditional formatting off, redoing it all to no avail.
I
am stumped

Any ideas?