Use conditional formatting:

Pull-down: Format Conditional Formatting... and set the conditions
--
Gary's Student


"Ray" wrote:

I need to format the background color of the cell according to the score.
Is there any function to serve this purpose? Your guidance is appreciated.

Thanks,

Ray