| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula to type 1 in B2 if A2 has the color green?
Is there a way to make a formula that recognizes the cell color like if A2 is
green, then my formula in B2 would recognize this color and return the value 1, then 0 for yellow and -1 for red for example. - a form of reverse conditional formatting. If not, how to to this in vba? Rgds |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the color in a chart, so POSITIVE values is e.g. GREEN and | Charts and Charting in Excel | |||
| Change a cell color based on a certain value (green or red) | Excel Worksheet Functions | |||
| conditional formatting COLOR - pale green | Excel Discussion (Misc queries) | |||
| I want the bar chart with customer selected colors, green color f. | Charts and Charting in Excel | |||
| Format color - darker green available? | Excel Worksheet Functions | |||
Threaded Mode
