yes- go to Format and select Conditional Formatting. It works like a formula
box with IF (cell) is equal/greater/less than than XXXX, then (insert format
result- like Font Red)

"David" wrote:

Can I format a cell to automatically show a value in red if the value is a
negative %?