View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Conditional Formatting Issue

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?