Jim,

I think you can use "Conditional Formatting" on what you are looking for.

The "Conditional Formatting" is in the Format menu.

Hope this helps.

"jim mcgrath" wrote:

Help Please,
for a formula which would look at a value in a cell; ie 0, & if 0 then
colour fill a related cell as a warning