Conditional Formatting

[Guest]

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?

 

[Rowan]

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 =A1>B1 (or whatever you want
your check to be) and set your formatting.

Hope this helps
Rowan