Hi
use 'Format - conditional format' for this

"John V" wrote:

Can the results of a formula drive color shading? How? Can it be nested?
Example if cell equals "x" then red, if cell equals "y" then green.

Thanks for any help.