Replace based on combobox value
I currently have a combobox that shades in cells based on
a combobox value. Each cell has a formula that inputs a cells value based on another cells value unless the value is "0". If the value is "0" it inputs "SPARE" but if the cell is shaded via the combobox, I want the input for a "0" value to be "N/A". How is this done if possible? Can I do the formula based on the cell shading or does it have to be set to the combobox. Any help is appreciated, Mike |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com