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
|