View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
myssieh myssieh is offline
external usenet poster
 
Posts: 15
Default Conditional Formatting Problem

Good Morning, I have a strange problem and it's driving me crazy... I am
running Excel 2003

I have added a conditional formating to cell Z17 that says

Cell Value Is less than =$D$17 (cell D 17 contains 90.0%) then format the
cell contents to red fond...

the problem is... Cell z17 contains 90.0% and it is turning red. I don't
understand how this is possible when I told it less than.

Can someone please help?

Thanks in advance.