software

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: www.excelforum.com/member.php...oamp;userid=31930
View this thread: www.excelforum.com/showthread...hreadid=516561Conditional Format the cell
got format
conditional format
then select if cell value is less than....
well you will see what to doHi Mac,
Select A1gt;Formatgt;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 quot;=A1lt;B1quot; (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 JohnsonHi,

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][lt;96]0%;General

Regards,

Ashish Mathurquot;MikeMcquot; wrote:

gt;
gt; Cell A1 shows 83.3%. Cell B1 has a floor of 95.5%. How can I change A1
gt; to red if % is less that B1?
gt;
gt; Thanks
gt;
gt; Mac
gt;
gt;
gt; --
gt; MikeMc
gt; ------------------------------------------------------------------------
gt; MikeMc's Profile: www.excelforum.com/member.php...oamp;userid=31930
gt; View this thread: www.excelforum.com/showthread...hreadid=516561
gt;
gt;

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