Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating help.
Hello,
What function do I use in conditional formating? I have part number on sheet1, I would like the cell the turn different color if the part number on the cell equal any of the cells on column A. There are hundred of rows. THANKS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating help.
Hi,
Select column a and then Format|conditional format|formula is paste this in =COUNTIF($A$1:$A$10000,A1)1 Pick a colour and click OK "Cam" wrote: Hello, What function do I use in conditional formating? I have part number on sheet1, I would like the cell the turn different color if the part number on the cell equal any of the cells on column A. There are hundred of rows. THANKS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating help.
Mike,
I forgot the mention that the problem is the data where the conditional formating is on sheet1, but the reference data in column A is actually in sheet2. They are not on the same sheet. "Mike H" wrote: Hi, Select column a and then Format|conditional format|formula is paste this in =COUNTIF($A$1:$A$10000,A1)1 Pick a colour and click OK "Cam" wrote: Hello, What function do I use in conditional formating? I have part number on sheet1, I would like the cell the turn different color if the part number on the cell equal any of the cells on column A. There are hundred of rows. THANKS |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating help.
You can't refer directly from CF to cell references on another sheet, you
can get away with naming a range and using the name. -- David Biddulph "Cam" wrote in message ... Mike, I forgot the mention that the problem is the data where the conditional formating is on sheet1, but the reference data in column A is actually in sheet2. They are not on the same sheet. "Mike H" wrote: Hi, Select column a and then Format|conditional format|formula is paste this in =COUNTIF($A$1:$A$10000,A1)1 Pick a colour and click OK "Cam" wrote: Hello, What function do I use in conditional formating? I have part number on sheet1, I would like the cell the turn different color if the part number on the cell equal any of the cells on column A. There are hundred of rows. THANKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions |