Forum Discussion
Laura_B
Apr 15, 2019Copper Contributor
Conditional Formatting Relative References Not Working
Hi - I am currently working on writing a conditional formatting rule that will highlight a cell if the value of a cell in column B (B1) is within 5% of another cell (A1) in column A. I've been able ...
stv1vy
Apr 15, 2019Copper Contributor
Remove the $
SergeiBaklan
Apr 15, 2019Diamond Contributor
stv1vy , if use relative reference when values in B will be compared with ones in C