I am trying to compare two columns in Excel.

December 30, 2012 at 02:24:02
Specs: Windows XP
I am trying to compare two columns in Excel. Eg:

1 1
2 1
3 3
4 4
5 3
6 5
2 1
5 2
5 5
4 3
I would like to be high light or format thos cells where B < A. I want to apply it in 1400 rows. Can any one help out me?

See More: I am trying to compare two columns in Excel.

February 13, 2013 at 21:09:53
have you tried conditional formatting?
select the first cell in Col.B and open conditional formatting
(or it may be best to select a cell in Col. B that you already know is greater than the adjecent cell in Col. A...that way you'll know right away if this works properly)
select New Rule
Select the "Use Formula"
and try this: =b2>a1
then select whatever type of formatting you would like
then enter, ok, apply whatever buttons are left to set the format
then you can take the Paint Brush tool to copy the new formatting for the above selected cell and apply it to the rest of Col.B

Report •

February 14, 2013 at 01:23:38

First, you are replying to a question that is a 1.5 months old. I doubt OP is still looking for an answer. ;-)

Second, you can select the entire Column B and applying the CF in one step. No need to use the format painter. Just enter the rule for the first cell and it will be applied to every selected cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question