software

I want to compare 2 cells. If cell a1 is less than cell a2, then I want cell
a1 to be red. How do I do that?
Thanks.

I found it: Conditional Formatting

quot;GScottquot; wrote:

gt; I want to compare 2 cells. If cell a1 is less than cell a2, then I want cell
gt; a1 to be red. How do I do that?
gt; Thanks.


Use Conditional Formatting.

Select cell A1. Go to Format Menugt;Conditional Formatting. Condition 1
should be:

Box 1, Cell Value is: box 2, less than box 3, A2

Click on Format, Patterns Tab. Select the color you want to have A1
fill if the condition is true. Click OK, OK.

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=529277