Background color change, by using the formula.

's Computer Specifications

I want to change the background color of the cell by using conditional formula.
like...
Cell A1's Background color should be
Red, if B1>C1
Black, if B1=C1 &
Green, if B1<C1.

's Computer Specifications

Select A1
Go to Format --> Conditional Formatting...
Choose Formula is and enter: =B1>C1
format your background by clicking on format...
then add a rule and change to Formula is and enter:
=B1=C1 and format the background.
and then last but not least add the last rule, change
to formula is and enter: =B1<C1

hth

Carlo

On Dec 21, 3:03*pm, Sarveshwar Trangadia <Sarveshwar
Tranga...@discussions.microsoft.com> wrote:
> I want to change the background color of the cell by using conditional formula.
> like...
> Cell A1's Background color should be
> * * * * * *Red, if B1>C1
> * * * * * *Black, if B1=C1 &
> * * * * * *Green, if B1<C1.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto change background of color based on formula	=?Utf-8?B?ZnJlZHdpbmc=?=	Microsoft Excel Worksheet Functions	3	4th Jan 2007 12:45 AM
Change font and background color of several cells based on result of a formula	Zenaida	Microsoft Excel Misc	2	27th Apr 2006 06:46 PM
Dynamically change cell range in formula by background color?	albert@netmation.com	Microsoft Excel Programming	1	9th Jan 2006 09:08 PM
How do I change a cell background color in a formula ...	=?Utf-8?B?RWJlblZpbGpvZW4=?=	Microsoft Excel Misc	2	18th Nov 2004 10:05 PM
I need the formula to change the background color in one cell bas.	=?Utf-8?B?d2lsbG93c3dhbg==?=	Microsoft Excel Worksheet Functions	2	17th Sep 2004 07:35 AM