Excel Conditional Formatting (Compare Vals in 2 Columns)

I want to use Conditional Formatting to highlight numeric cells in one
column that are less than the value of cells in lower records and an
adjacent column. I have tried using INDEX, with limited results.

Will this require a VLookUp + INDEX?

Any ideas?

Brian

I think you'll need to post a small example of data so we can see what you
mean.

--
Biff
Microsoft Excel MVP


wrote in message
...
I want to use Conditional Formatting to highlight numeric cells in one
column that are less than the value of cells in lower records and an
adjacent column. I have tried using INDEX, with limited results.

Will this require a VLookUp + INDEX?

Any ideas?

Brian

Here is what I have so far
=AND(COUNT(INDEX($A$1:$AZ$1000,ROW()+1,COLUMN())-1)=$C53)
....but I'm pretty sure I'll have to build an array to process the data.


"T. Valko" wrote:

I think you'll need to post a small example of data so we can see what you
mean.

--
Biff
Microsoft Excel MVP


wrote in message
...
I want to use Conditional Formatting to highlight numeric cells in one
column that are less than the value of cells in lower records and an
adjacent column. I have tried using INDEX, with limited results.

Will this require a VLookUp + INDEX?

Any ideas?

Brian

=AND(COUNT(INDEX($A$1:$AZ$1000,ROW()+1,COLUMN() )-1)=$C53)

That really doesn't help to explain what you're trying to do.

You don't need the AND or the COUNT functions because you're only comparing
a single cell to C53.

Let's assume that is the cf formula applied to cell C6. Here's what that
formula means:

B7=$Cxx


--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
Here is what I have so far
=AND(COUNT(INDEX($A$1:$AZ$1000,ROW()+1,COLUMN())-1)=$C53)
...but I'm pretty sure I'll have to build an array to process the data.


"T. Valko" wrote:

I think you'll need to post a small example of data so we can see what
you
mean.

--
Biff
Microsoft Excel MVP


wrote in message
...
I want to use Conditional Formatting to highlight numeric cells in one
column that are less than the value of cells in lower records and an
adjacent column. I have tried using INDEX, with limited results.

Will this require a VLookUp + INDEX?

Any ideas?

Brian