Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting colored cells to numbers- is there a formula?
I'm importing a report that generates colored cells that represent different
values. I need to change those colored squares to numbers to work with the values. Is there such a formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting colored cells to numbers- is there a formula?
Here is a 1 line function that will do the trick
Function GetColorIndex(myrange As Range) As Integer ' ' GetColorIndex = myrange.Interior.ColorIndex End Function Call it from the excel spreadsheet with =GetColorIndex(A25) or any cell you want. "Math Geek" wrote: I'm importing a report that generates colored cells that represent different values. I need to change those colored squares to numbers to work with the values. Is there such a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i formulate to add certain colored numbers? | Excel Discussion (Misc queries) | |||
What formula can I use to sum only certain colored cells in an exc | Excel Worksheet Functions | |||
Converting Formula answers to numbers | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |