| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel function help
Say the top left item is in cell A1
then select cell A1 From the menu bar, Format/Conditional Formatting set condition 1 from "Cell Value is" to "Formula Is" using the dropdown arrow, and enter the formula COUNTIF("$A1:$F1,A1)1 and choose format blue background Finally copy cell A1 to the clipboard and PasteSpecial formats only to the other cells. "Francesco" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel function help
Oops, formular should start with "="
"Jack Schitt" wrote in message ... Say the top left item is in cell A1 then select cell A1 From the menu bar, Format/Conditional Formatting set condition 1 from "Cell Value is" to "Formula Is" using the dropdown arrow, and enter the formula COUNTIF("$A1:$F1,A1)1 and choose format blue background Finally copy cell A1 to the clipboard and PasteSpecial formats only to the other cells. "Francesco" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel function help
On Fri, 3 Sep 2004 10:10:25 +0100, "Jack Schitt" wrote: Say the top left item is in cell A1 then select cell A1 From the menu bar, Format/Conditional Formatting set condition 1 from "Cell Value is" to "Formula Is" using the dropdown arrow, and enter the formula COUNTIF("$A1:$F1,A1)1 and choose format blue background Finally copy cell A1 to the clipboard and PasteSpecial formats only to the other cells. Thanks, but something is wrong. I want that every record in the row confronts the other records, non only with A1. I hope will be clear... :: Francesco |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel function help
"Francesco" wrote in message ... On Fri, 3 Sep 2004 10:10:25 +0100, "Jack Schitt" wrote: Say the top left item is in cell A1 then select cell A1 From the menu bar, Format/Conditional Formatting set condition 1 from "Cell Value is" to "Formula Is" using the dropdown arrow, and enter the formula COUNTIF("$A1:$F1,A1)1 and choose format blue background Finally copy cell A1 to the clipboard and PasteSpecial formats only to the other cells. Thanks, but something is wrong. I want that every record in the row confronts the other records, non only with A1. I hope will be clear... :: Francesco It should still work, I think. If you enter "A1" without preceding dollar signs (ie A1 not $A$1) then when you copy the format to other cells the reference to A1 should change also to the reference of the destination cells. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel function help
I did notice a typo in the original formula;
Should be =COUNTIF($A1:$F1,A1)1 not COUNTIF("$A1:$F1,A1)1 You may have already noticed that. |
| Reply |
| 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)
Linear Mode
