Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting to Compare to Lists | Excel Worksheet Functions | |||
Compare two Sheets with Conditional Formatting | Excel Discussion (Misc queries) | |||
Compare two Sheets with Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional formatting - compare 2 dates | Excel Discussion (Misc queries) | |||
Conditional Format ... Compare Columns? | Excel Discussion (Misc queries) |