If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Excel Conditional Formatting (Compare Vals in 2 Columns)
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Excel Conditional Formatting (Compare Vals in 2 Columns)
=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 |
Thread Tools | |
Display Modes | |
|
|