Conditional Formatting Comparing Values in Two Columns

Hello guys,

I am on xls 2007, I have two columns let’s say with data in it. I want to use conditional formatting to be able to do the following and fill the cells based on the following condition:
IF THE NUMBER IS A1 IS GREATER THAN B1, COLOR IN GREEN, IF FALSE COLOR IN RED.

Thanks guys.

Choose Use a formula to determine which cells to format and enter formula =A1>B1

then click Format and choose Green from Fill tab.

Click Ok

Click New Rule and then Use a formula to determine which cells to format and formula:

=A1<=B1 and click Format and choose Red.

perfect thanks

last thing can you help me achieve this, I simulated the results in the attached spreadsheet.
IF E<G THEN FILL "E" IN GREEN, AND FILL "G" IN RED

You have to do them seperately, so select the E range and Use a formula to determine which cells to format and enter formula

then formula: =E9<G9 and Format choose Green

Then select G range and use same formula: E9<G9 and Format choose Red.

Thank you very much NBVC! It worked great!