| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA colorscale and color #
hi,
i have a colorscale (conditional formating ) in range A1:A20 and I'm trying to get color number for each cell. In normal case a = Range("a1").Interior.Color b= Range("a2").Interior.Color etc. works fine. But when colors of cells are from conditional formating i dont know how to get color number. how to do that? Mistus |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Threaded Mode
