Change cell colour based on an IF statment

's Computer Specifications

How can I make a cell change colour based on and IF statment.

I want one cell to go red if the value in another cell is negative.

Thank you.

Richard

's Computer Specifications

You could use conditional formatting.

Seelct your cell then
Format|Conditional format
Select formula is and enter the formula
=$B$1<0

Select a colour
Ok

Mike

"VoxBox-Richard" wrote:

> How can I make a cell change colour based on and IF statment.
>
> I want one cell to go red if the value in another cell is negative.
>
> Thank you.
>
> Richard

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using CF to change colour in cell based on date?	Steve	Microsoft Excel Misc	4	21st Mar 2010 10:52 PM
how do i change cell text colour based on value in other cell	Oscarrot	Microsoft Excel Worksheet Functions	2	20th Jul 2009 03:21 PM
Change 3rd cell colour based on cell 1 >= cell2 in range	wombarrapete	Microsoft Excel Discussion	8	21st Dec 2008 09:41 PM
change current cell colour based on the value of adjacent cell on other worksheet	Rits	Microsoft Excel Programming	2	23rd Nov 2006 11:57 AM
Need a cell to change colour based upon a word in another cell	=?Utf-8?B?Y29va2ll?=	Microsoft Excel Misc	4	11th Nov 2004 05:50 PM