Conditional Form. Column

[rusted314]

Hi,
If I have 2 columns of data how do I highlight all of the data in Column A in Red that is less than Column B. Ie. A2<B2, A3<B3 etc. Is there a way to do this other than 1 at a time? These are all dollar values.
Thanks

 

[jeffreybrown]

Are you comparing A1 to B1, A2 to B2 etc.?

 

[rusted314]

Yes. Exactly. Thanks

 

[jeffreybrown]

Then in conditional formatting you should be able to add =A1 < B1 and then pick your format.