I would like to have, say:

cells C7 & D7 to turn into red when G7="a"; blue when G7="b"; yellow when
G7="c". Cells C7 & D7 are constant; only G7 changes. This will go on with the
following rows.

I've downloaded and read the sample from office online help but the closest
I could find was "shadow an entire row when several criteria must be true"
but I can't emulate the formula into mine.