Conditional Formatting

R

RJ

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?
 
R

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
 
Top