| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get a cell's color with a formula, not with visual?
I'm trying to detect cells with color, but I don´t want to use VBA code. I
don´t know if is possible using formulas. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get a cell's color with a formula, not with visual?
You should checkout:
http://www.cpearson.com/excel/colors.htm even though it relies on VBA, its really not all that painful. -- Gary's Student gsnu200705 "Potosi" wrote: I'm trying to detect cells with color, but I don´t want to use VBA code. I don´t know if is possible using formulas. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get a cell's color with a formula, not with visual?
Without VBA you will have to visually look for cells with color unless they were
colored using Condtional Formatting. In the latter case you can search or filter on the CF value that colored the cells. As an alternative, you could use EditFindOptionsFormatChoose format from cell. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 14:07:00 -0800, Potosi wrote: I'm trying to detect cells with color, but I don´t want to use VBA code. I don´t know if is possible using formulas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A) | Excel Discussion (Misc queries) | |||
| In Excel is there a function to change a cell's background color? | Excel Worksheet Functions | |||
| change cell background color when another cell's value = 40 | Excel Discussion (Misc queries) | |||
| Changing the color of a Series Collection using visual basic? | Charts and Charting in Excel | |||
| Change a cell's fill color dynamically? | Excel Discussion (Misc queries) | |||
Hybrid Mode
