Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Well, I want to compare 6 numbers against another 6 numbers which are set. So
I want the first number to check against all 6 of the set numbers and then the second number to check all the set numbers and so on, and if they match I want the number to highlight in yellow. So if we say: - Set Chosen 3 6 This 6 is in the 'Set' Number list 6 10 12 14 13 17 This 17 is in the 'Set' number list 17 20 21 27 So basically I want the 6 and 17 in the 'Chosen' list to be highlighted in yellow. Are you with me? And any ideas if so? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reading Cell Function??? | Excel Worksheet Functions | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
Function making cell really "empty" | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |