Percentages to include changing cell's color

Giganews Newsgroups
Subject: Percentages to include changing cell's color
Posted by:  SGT David C. Glasgo (nirac80-exc…@yahoo.com)
Date: Thu, 23 Oct 2003

Is it possible to have a formula or macro to change the
color of the cell based on a percentage in the cell?

Like if the percentage comes out to be 0% the cell should
be red.

If the percentage comes out to be 50% then the cell should
be yellow.

If the percentage comes out to be 100% then the cell
should be green.

Is it possible to have these colors automatically changed
instead of having to manually change them?

Replies