| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List or colour Cells of results
Excel 2007
=If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A $13,B2),"") The above formula is looking at a figure in a selected cell then looks in the selected array to match that figure and then count how many occurences if any. What I would also like to have is a formula to tell me in what cells the matches are or highlight the cells of the matches. Is this possible or am I being overambitious? -- Jamie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
List or colour Cells of results
-- Jamie "Jamie" wrote: Excel 2007 =If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A $13,B2),"") The above formula is looking at a figure in a selected cell then looks in the selected array to match that figure and then count how many occurences if any. What I would also like to have is a formula to tell me in what cells the matches are or highlight the cells of the matches. Is this possible or am I being overambitious? -- Jamie I have found a previous posting for showing what cells the corresponding figure is in but would still like to know if i can get the cell that figure is in to colour fill also. Jamie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
| No colour in cells when blank in list | Excel Worksheet Functions | |||
| replace results from list with corresponding list | Excel Worksheet Functions | |||
| Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
| can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions | |||
Linear Mode
