View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
debra49424 debra49424 is offline
external usenet poster
 
Posts: 6
Default Conditional Formatting Issue

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?