View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur
 
Posts: n/a
Default Negative Percentage?

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