| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Excel formulas based upon the color shading of a cell?
Is there a way to execute a formula in Excel that references the current
color shading of a cell so that I can place a value in a corresponding cell? Example: If cell A1 is shaded green the cell A10=8 |
|
#2
|
|||
|
|||
|
Try this. Might work
If Range("A1").Interior.ColorIndex = 4 Then Range("A10").Value = 8 ElseIf Range("A1").Interior.ColorIndex = 5 Then Range("A10").Value = 10 ElseIf Range("A1").Interior.ColorIndex = 6 Then Range("A10").Value = 12 Else -- -- -- -- -- End If "DGBG" wrote: Is there a way to execute a formula in Excel that references the current color shading of a cell so that I can place a value in a corresponding cell? Example: If cell A1 is shaded green the cell A10=8 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel formulas | Excel Worksheet Functions | |||
| can you place an alarm or tickler mechanism within excel based on. | Excel Worksheet Functions | |||
| can you place an alarm or tickler mechanism within excel based on. | Excel Worksheet Functions | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
| Excel Formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
