Excel Conditional Formatting (Compare Vals in 2 Columns)
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
|