color cells based on nocompares

[tcurrier]

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....

 

[HalfAce]

Hello tcurrier,
You can use Conditional Formatting for this.
In A1, go to Format > Conditional formatting.
For the first field use 'Cell value is'
In the second field choose 'not equal to'
In the third field enter this: =$D1
Click the Format button > Patterns tab and choose the desired color.
Click OK, OK.
Copy A1 and paste to A2:A20.

For column D, simply repeat the process using =$A1 in the third field instead of =$D1.

You should be good to go.

 

[tcurrier]

Thank you very much !

 

[HalfAce]

Most welcome. Glad it helped.