Hi
You can use conditional formatting. Format-conditional formatting, and there
you can make criterias and even formulas that will change the background and
scriptcolour.
Yes... Use conditional formatting in the format menu. you can set the
condition for which the colour of either the font or the background or both
can change.