Re: Conditional Formatting Problem
- From: "Don Guillett" <dguillett1@xxxxxxxxxxxxx>
- Date: Fri, 15 Feb 2008 08:57:28 -0600
Try using the formula box and typing in
=z71<$d$17
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"myssieh" <myssieh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:3B63616C-3F66-4448-9AFC-C7DB425CB1D0@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Problem with Autorecovery in Excel 2003 (over RDC)
- Next by Date: Re: WORK*** SORTING NOT WORKING?
- Previous by thread: Re: Problem with Autorecovery in Excel 2003 (over RDC)
- Next by thread: Re: Conditional Formatting Problem
- Index(es):
