| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell color
Excel 2003, should work in Excel 2000 as well
to simply filter on cell colors you might use the following function: Function kolor(cell As Range) As Integer kolor = cell.Interior.ColorIndex End Function press Alt+F11 then Insert-Module and paste the a/m code presume you want to determine color of A1 then in B1 insert the following: =kolor(A1) copy down and apply autofilter HIH |
| 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) | |||
| Make text color match cell color with macro? | 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) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
![Jarek Kujawa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
