Did you try before you said it won't work?

You need to have a look at the help files on "relative and absolute cell
references" and see how Excel will increment a cell address throughout a
selection of cells.

Just for practice........forget CF

Enter =A1 in B1

Drag/copy down to B10

Check each cell to see how the A1 reference increments.

Formulas in CF do the same thing.


Gord Dibben MS Excel MVP


On Thu, 17 Sep 2009 10:21:32 -0700, Nelson
wrote:

This wont work, I need to say that if I1H1 turn red and if I2H2, I3H3, so
on and so on.

Can this be done without having to set a conditional format on each row?