comparing 2 values in different cell and producing results

[cteq1]

I am sorry but I am not too much of techie but I am sure the excel must do
following..

What I want to do is..

Cell A1 has say number 10 and cell B1 has 15
Cell A2 has 15 and cell B2 has 10

both A1 and 2 and B1 and B2 cells have formula so the result is the numbers
above.

I want to compare A1 and B1 cells and if B1 is negative ie more then A1
then it should turn red.

can this be done?

 

[AltaEgo]

You need to apply conditional formatting. For help on this see:
http://www.contextures.com/xlCondFormat01.html

 

[cteq1]

Thank you very much. It did the trick.

You need to apply conditional formatting. For help on this see:
http://www.contextures.com/xlCondFormat01.html