I have a spreadsheet with columns of numbers, where I'd like to color all of the cells in columns a1 - a20 that don't match their corresponding numbers in columns d1 - d20. For example, if a5 doesn't match d5, I want to change the color of both cells to yellow.
Can anyone suggest an easy way to do this ?
Thanks....
Can anyone suggest an easy way to do this ?
Thanks....