hi,
use conditional formating.
on the tool bar....Formatconditional formatihng
enter this.....if cell value is......less than.......0
format to gray.

regards
FSt1
"roxiemayfield" wrote:

How do I have the cell turn gray if the sum is less than 0