The way conditional formatting works is that "if some calculation = true" then apply the color. For example, "if A1 = x." So can you just use the same calculation in the above cells? Like "if A1 = x, then return C6, otherwise do something else."