Fill CELL color Red

[Dave]

Hi all

Using Excel 2002

In SHEET1 column (AC) is text values with duplicates, In column (AA) is
numbers. What I'm trying to do is if a text value as The number 1 to the
left of it in (AA), in the next Text cell down in (AA) with the same value
make the Fill colour red. and apply this to the sheet to work when new rows
are added.

AA AC
1 JOHN ( Would be Fill colour Red because AA4 = 1
2 JANE Would Not be red
0 JANE Would Not be red
1 JOHN Would Not be red because AA5 is not a number 1
0 JOHN ( Would be Fill colour Red because AA7 = 1
5 JANE ( Would be Fill colour Red because AA8 = 1
1 JOHN Would Not be red
1 JANE Would Not be red

Thanks in advance

Dave