i looked into that but it all seems to be based on your filling the cell with
the value. i need to fill a cell based on a value from ANOTHER cell. if you
know what condition to use, it would be appreciated. thanks.

"Gary''s Student" wrote:

Use Conditional Formatting.
--
Gary''s Student - gsnu201001


"r2rcode" wrote:

can i fill a cell with a color based on a value from another cell?