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
