Select the column (eg A) so that A1 is the activecell - should be white
and you should see A1 in the Name Box on the Formula Bar. Then in
conditional formatting enter Formula Is =A1B1 (or whatever you want
your check to be) and set your formatting.

Hope this helps
Rowan

RJ wrote:
How can I set up conditional formatting so that I can compare data in a
column to baseline data in adjacent cells so that I do not have to do it cell
by cell?