Simple Conditional Formatting question...

[Danny Boy]

Not simple for me, but maybe for you...

In column A, I have a list of names
In column B, numbers for each name
Column C, more names
Column D, numbers for these names

Question, I want to compare the 2 numbers in each row and highlight the name corresponding to the higher number.

Thanks, in advance

[Danny Boy]

...By highlight, I mean shade (fill) and by name, I mean the cell containing the name

[Jay Petrulis]

On 2002-04-16 17:02, Danny Boy wrote:
Not simple for me, but maybe for you...

In column A, I have a list of names
In column B, numbers for each name
Column C, more names
Column D, numbers for these names

Question, I want to compare the 2 numbers in each row and highlight the name corresponding to the higher number.

Thanks, in advance

How is the comparison to work?

If as in the following:
A1: Jay
B1: 10
C1: Danny
D1: 20

(you must've cheated to score higher than me)

In Cell A1
Format>Conditional Formatting
FormulaIs =B1>D1

In Cell C1
Format>Conditional Formatting
FormulaIs =D1>B1

format to suit and copy down the range.

If you want to match the names in each column, say

A1: Jay
A2: Danny
C1: Danny
C2: Jay

and you want to compare Jay's scores in A and C (B1 vs D2) separately from Danny's scores in A and C (B2 vs. D1), then I'll leave that one to Aladin. My brain is too fried right now to work on that and he'll do it much better.

Bye,
Jay



[ This Message was edited by: Jay Petrulis on 2002-04-16 17:54 ]

[Danny Boy]

Thanks Jay, you got it with the first one...