I need help with a macro that changes the color of a cell column range depending on the words in a cell out of the range.
For example, if B12="JSP-MIC" the color of B13-B19 should be yellow,
If B12="JSP-AOUT" the color of the range should be green,
If B-12=". . ." the color of the range should be grey.
There are additional values for B12, but those are the only three colors.
I have started several times, but I am getting nowhere fast.
Thanks
For example, if B12="JSP-MIC" the color of B13-B19 should be yellow,
If B12="JSP-AOUT" the color of the range should be green,
If B-12=". . ." the color of the range should be grey.
There are additional values for B12, but those are the only three colors.
I have started several times, but I am getting nowhere fast.
Thanks