Select A1
Go to Format -- Conditional Formatting...
Choose Formula is and enter: =B1C1
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
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 B1C1
* * * * * *Black, if B1=C1 &
* * * * * *Green, if B1<C1.