Hello,
I have a column of numbers that "could" be dynamic. I've copied over the numbers to another column as "text" so the copied column will be static. I want to add "Conditional Formatting down the static column to highlight if the numbers are not equal. I know how to add a "Conditional Formatting" to one cell if it "does not equal" another cell, (such as if "M13 "does not equal" J13). But can anyone tell me how to copy that "Conditional Formatting" down the M column to compare to each adjacent cell (M13/J13... M14/J14.. M15/J15... M16/J16...etc)? Thanks!
I have a column of numbers that "could" be dynamic. I've copied over the numbers to another column as "text" so the copied column will be static. I want to add "Conditional Formatting down the static column to highlight if the numbers are not equal. I know how to add a "Conditional Formatting" to one cell if it "does not equal" another cell, (such as if "M13 "does not equal" J13). But can anyone tell me how to copy that "Conditional Formatting" down the M column to compare to each adjacent cell (M13/J13... M14/J14.. M15/J15... M16/J16...etc)? Thanks!