| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2002
Hello all,
If I have in A1 red background color. What should i write down in B1 inroder to return the color value of A1? Is it a function or vba code? Thanks Amir |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002
Hi,
Range("b1").Interior.ColorIndex = Range("a1").Interior.ColorIndex ' Set colour Range("b1= Range("a1").Interior.ColorIndex ' Value of colour index "אמיר" wrote: Hello all, If I have in A1 red background color. What should i write down in B1 inroder to return the color value of A1? Is it a function or vba code? Thanks Amir |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2002
Function ColorIndex(rng As Range)
If rng.Cells.Count = 1 Then ColorIndex = rng.Interior.ColorIndex End If End Function use like =ColorIndex(A1) -- HTH Bob Phillips "????" wrote in message ... Hello all, If I have in A1 red background color. What should i write down in B1 inroder to return the color value of A1? Is it a function or vba code? Thanks Amir |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Unable to open files in MS Outlook 2002 | Excel Discussion (Misc queries) | |||
| Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
| Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time | Excel Programming | |||
| Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) | |||
| Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming | |||
Hybrid Mode
