| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I identify cell color for comparison?
A coworker tasked me with finding this out:
Either by formula or by code, how can one return the color code for a cell? What he wants to do is be able to say something to the effect of "IF cell a2 is GREEN, then add a2+b2, ELSE IF cell a2 is RED, then..." I'm sure the answer to this is in an Excel VB book somewhere, but our company is too cheap to buy one. Thanks in advance, Jackyl71 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How identify data of two coulams,Every cell count and show result | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Threaded Mode
