Conditional Formatting

Closed
Report
Posts
1
Registration date
Wednesday April 12, 2017
Status
Member
Last seen
April 12, 2017
-
Hello everyone,
I'm trying to compare a table from one sheet to one on another sheet, and was wondering if its possible to copy the conditional formatting from one cell the the rest of the table. i tried it but it copies the value of the original cell, i need it to take value of the correspong cell which its getting copied to.

ex.
sheet 1
PRODUCT CHOICE SELECT NO ROLL
CHUCK ROLL 215 250 240

sheet 2
PRODUCT CHOICE SELECT NO ROLL
CHUCK ROLL 245 245 240

pic with rule attached.
any ideas?

thank you