| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Shading
How can I determine the color of cell shading using a function or expression?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell Shading
Excel has no worksheet function that will do this.
How did the cell get its shading? Manually or by Condtional Formatting? See Chip Pearson's site for user defind functions to cover the above http://www.cpearson.com/excel/colors.htm. Note the caveat about Conditional formatting and the link to another page. Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 10:38:01 -0700, Ray wrote: How can I determine the color of cell shading using a function or expression? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to sort the data by cell shading or cell color? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
| cell shading | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Linear Mode
