excel formula compare column A with B highlight re the bigger figure

Question

excel formula compare column A with B highlight re the bigger figure

Ulrike Froitzheim 0

0 comments

2 answers

Your answer

Answer 1

If you want to compare columns A and B and highlight the larger number in each row, use Conditional Formatting.

For column A, use this formula:

=A1>B1

For column B, use this formula:

=B1>A1

Apply each rule to the appropriate column range, for example A1:A100 and B1:B100. Set the desired highlight format for each rule. If A and B are equal, neither cell will be highlighted.

If your data starts on a different row, such as row 2, use:

=A2>B2

=B2>A2

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin

Answer 2

To compare values in column A and column B, use a logical comparison formula such as:

=A1>B1

This returns TRUE when the value in column A is greater than the value in column B, and FALSE when it is not.

To highlight the bigger figure with conditional formatting:

Select the cells to format.
Go to Home > Conditional Formatting > Manage Rules.
Select New Rule.
Choose to use a formula to determine which cells to format.
Enter a formula that returns TRUE or FALSE.

Examples:

To highlight cells in column A when A is bigger than B: =A1>B1
To highlight cells in column B when B is bigger than A: =B1>A1

Then choose the format color and apply the rule.