Conditional Formatting

  • Thread starter Thread starter gibbylinks
  • Start date Start date
G

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
 
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.
 
Back
Top