The feature to do this is called Conditional Formatting

Highlight the cells you wish to format, then do Format
ConditionalFormatting CellValueIs LessThan 0 Format PatternsTab
select a color OK OK

Vaya con Dios,
Chuck, CABGx3



"Pat Mineard" <Pat wrote in message
...
what is the formula that is used if any to color code a cell or many cells
that the amount reaches minus within a spreadsheet, such as total
is -$5.69
in a roww and you may have others that may go in the minus
How can you color code that cell and others if the amount reaches a minus?
I would really appriciate any help because I am working on a expenditure
report

Thank you

Pat Mineard