Highlight cell based on the value

[varunwalla]

Hi,

How can i highlight the cell on b4 based on the value i.e if it is positive the background of the cell should be in green color if it is in negative the background of the cell should be red

Book1
	A	B
1	Enter Value First Value	300
2	Enter Value Second Value	200
3
4	Total	100
Sheet1

Cell Formulas
Range	Formula
B4	B4	=B1-B2

 

[Fluff]

You could use conditional formatting & use =B4>=0 for Green & =B4<0 for red