Conditional Formatting Issue

D

debra49424

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?
 
L

Luke M

Do you mean, the formatting is not working, or your input of the formatting
is not being saved?

Perhaps there is an issue with cell formatting? (number vs text?)
 
D

David Biddulph

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

debra49424

the CF Conditions are:

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 are:

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
 
D

David Biddulph

Perhaps your calculation in C13 doesn't come to exactly 67?
In a spare cell, insert the formula =C13-67 (or =C13-67) and see what value
you get. You may need to change the formatting to show say 15 decimal
places. If it isn't zero, your CF won't go green. You may want to change
your CF to say equal to =ROUND(C13,3) to round C13 to allow your CF to
trigger if D13 =C13 within 3 decimal places. An alternative is to change
your formula in C13 to =ROUND(your_formula,3). Change the number of decimal
places to suit your requirements. You may want zero decimal places.

The other point is to be sure that you are working in a number of minutes,
not an Excel time which is a number of days (though can be formatted to
display in minutes).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top