Negative Percentage?

M

MikeMc

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
 
D

dmexcel

Conditional Format the cell
got format
conditional format
then select if cell value is less than....
well you will see what to do
 
K

Ken Johnson

Hi Mac,
Select A1>Format>Conditional formatting...
Then, in the top left box on the dialog use the down arrow to change
the box to read Formula Is.
Then, in the next box type "=A1<B1" (don't include the speech marks).
Then, click on the Format... button and choose the format you want (red
Font or red Fill).
Then click OK then the final OK.
Ken Johnson
 
A

Ashish Mathur

Hi,

There is an alternative to using conditinal formatting here:

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
 
K

Ken Johnson

Hi Ashish,
I thought Mac was comparing A1 with B1. Will plain formatting achieve
the required result when B1 changes to say 97% and A1 is 96.5% and
should therefore be red?
Ken Johnson
 
Top