| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function help
Hi 2 all.
I need help for a little problem. I've 5 row with 6 record, for example: |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Albert White | Luke Black | Mark Red | Lee Yellow | Mark Red | Maurice Pink | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| | Giovanni Rossi | Alberto bianchi | Mario Rossi | Carlo gialli | Patrizio Verdi | Maurizio Rosa | |-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------|-----------------------------| Now, i want to create a function that compare every record in a row and find 2 equals. Then if the first row contain 2 times "Mark Red" like in example, i want that the 2 equals become writes in BLU with background yellow. Sorry for my poor english, i hope that U understand my problem and help me to solve. Thanks. Francesco |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| When I Import an Access Table With an Excel Function in a Cell it Displays as Text not as a Function in Excel | Excel Programming | |||
| Excel - saving result of a function without showing the function | Excel Programming | |||
![Francesco[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
