Conditional Formatting
 

For every cell in a column, I would like to highlight red if the value is not
equal to the adjacent value in the next column.

I've set the conditional formatting for the first 2 cells
Is it possible to autofill conditional formatting for the rest of the column?

I'm sorry. Autofill is possible.
It didn't work for me because I did not take out the $ signs.

"Darren" wrote:

For every cell in a column, I would like to highlight red if the value is not
equal to the adjacent value in the next column.

I've set the conditional formatting for the first 2 cells
Is it possible to autofill conditional formatting for the rest of the column?