Select all of the rows, starting from 1

FormatConditional Formatting

Change Condition 1 to Formula Is
Add a Formula of =$A1$B1
Click format
Select Pattern
Choose a colour
OK out

--

HTH

RP
(remove nothere from the email address if mailing direct)


"converting 05445 to 2005-10-04"
om wrote in message
...
Hi,
I would like to change the row color according to an if statement.

if column A is bigger than column B than change the row color to blue
otherwise no change should occur. (i.e. if A1B1, A2B2, A3B3)

The change is on pre-existing data.

thank you,

Sten Melin