Change fill color of all dependent cells when value changes

  • The title says it all. I have a cell range with 5 possible entries and need the backgrounds color coded to these entries. Some entries are dependant on other entries, so the change of one cell would effect others. It is very simple in design:

    P = Yellow
    T = Green
    X = Gray
    F = Dark Green
    R = Red

    For individual modification I have it set-up with:

    When I enter a P in one cell it will change another cell to a T, requiring both cells to be recolored, but this script only seems to do one cell. To make it simple, I'd like it to update the entire cell range based upon the individual cell contents whenever any single cell is modified.

    Any ideas?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!