Hi,
There is an alternative to using conditinal formatting he
You can change the custom number format.
Press Ctrl+1.
Under the numbers tab, go to Custom
In the type field on the right hand site, type the following:
[Red][<96]0%;General
Regards,
Ashish Mathur
"MikeMc" wrote:
Cell A1 shows 83.3%. Cell B1 has a floor of 95.5%. How can I change A1
to red if % is less that B1?
Thanks
Mac
--
MikeMc
------------------------------------------------------------------------
MikeMc's Profile: http://www.excelforum.com/member.php...o&userid=31930
View this thread: http://www.excelforum.com/showthread...hreadid=516561