Conditional Formatting

[gibbylinks]

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

 

[Luke M]

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.