Does anyone know how to attribute a value based on a shading colour? I have cells C8:F20 and would like to attribute a value to each of these cells when they are either shaded 'good green', 'bad red' or 'neutral yellow' (the conditional format colours). The attributed values can be recorded in corresponding cells H8:K20. Any help would be great.