Solved Find out condition value and format by Comparing Two Columns

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

A B
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: Find out condition value and format by Comparing Two Columns

Report •


#1
December 30, 2012 at 06:10:07
✔ Best Answer
Please do not double post your request (also posted in Database section)
as it make it difficult to keep track of your question and answers.

You did not specify which version of Excel your using, so this is for 2003:

Conditional Formatting 2003

1) – Select your cell or range of cells, IE A1 thru B10

On the Menu Bar:

2) - Format
3) - Conditional Formatting
4) – Change “Cell Value is” to “Formula Is”
5) – Enter the formula:

=$B1<$A1

Sub Menu Format :
6) - Patterns
7) - Select a pretty color
8) - Press OK

See how that works for you.

MIKE

http://www.skeptic.com/


Report •

#2
December 30, 2012 at 06:12:03
I don't know what you mean by "not cell to cell".

If you are trying to highlight the cells in Column B when the value in Column B is less than the value in Column A in the same row then select Column B and use Conditional Formatting with this rule:

=B1<A1

The formatting will be applied to the entire selection on a Row by Row basis. In your example, B2, B5:B8 and B10 would be formatted.

    A   B	
1   1   1	
2   2   1 <--
3   3   3	
4   4   4	
5   5   3 <--
6   6   5 <--
7   2   1 <--
8   5   2 <--
9   5   3 <--

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


Report •

Related Solutions


Ask Question