Hi,

assuming that in the next cell you want to compare the entries on row 3 then
simply copy the format down. Or as step one suggested select all the cells
you want to format before you create the conditonal formatting. But note
that this formula assumes the first cell of that selection is on row 2.
Adjust if that is not the case.

You can copy formats using either the Format Painter or the copy, Edit,
Paste Special, Format command.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Oscar" wrote:

What if I want to repeat this condition to the next cell (C3)?

Thanks