Take a look at Format|conditional formatting

Gary King wrote:

Can I set some aspect of the cell format based on a formula value?

For example, I would like to change the cell fill color based on whether the
value in that cell is greater than or less than a value in another cell.

--
Gary King

--

Dave Peterson