comparing 2 values in different cell and producing results



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

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

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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question