When creating the conditional formatting rule, pay attention to whether the
formula uses absolute or relative cell references ($ symbol). This determines
how the format rule changes as its copied.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gibbylinks" wrote:

Is there a way to copy conditional formatting the same as formulas ?

I have a form where the formula increments with each row

=IF(ISNA(VLOOKUP(C26,Product_Data,2,)),"",VLOOKUP( C26,Product_Data,2,))
=IF(ISNA(VLOOKUP(C27,Product_Data,2,)),"",VLOOKUP( C27,Product_Data,2,))

But I can't use the conditional formatting unless I apply it seperately to
each line.

Thanks