Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the color of a cell
Hi all. I have a workbook that contains over hundred rows. Each row has a
colour indicating what worksheet it relates to. In a column at the end of the worksheet I would like to add a number that represents that colour so I can then filter by number (tried filtering by color but that was too much hard work). The workbook changes daily so doing it manually is a pain in the backside. I have searched the net and found VBA codes (which I would prefer not to use if possible) and came across this To get the colorindex of a specific cell, simply use (this is from xlDynamic.com) =ColorIndex(A1) I paste this into a cell and reference it correctly but it keeps coming up #NAME? any ideas. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the color of a cell
Install the VBA function at the bottom the the webpage.
-- Gary''s Student - gsnu200768 "Woodi2" wrote: Hi all. I have a workbook that contains over hundred rows. Each row has a colour indicating what worksheet it relates to. In a column at the end of the worksheet I would like to add a number that represents that colour so I can then filter by number (tried filtering by color but that was too much hard work). The workbook changes daily so doing it manually is a pain in the backside. I have searched the net and found VBA codes (which I would prefer not to use if possible) and came across this To get the colorindex of a specific cell, simply use (this is from xlDynamic.com) =ColorIndex(A1) I paste this into a cell and reference it correctly but it keeps coming up #NAME? any ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
How can I return a color instead of a value using the function "if | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) |