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

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

Hi Mac,
Select A1FormatConditional 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

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

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

Mike wanted A1 to show up red when it was less than B1