Formula Coloring

[jbarnett]

Could anyone inform me if there is a way to have a cell highlighted or
colored in the instance the sum is "0" or a "negative" number? My
columns are such that I update the "on hand" column daily and subtract
our "minimum inventory" column to equal the "over/under" column. It
would be super handy if I could make it so that any rows totalling zero
or less would stand out with red or any other color.

Much thanks for your input!

 

[Bernard Liengme]

Suppose the data is in A1100
Let the data to be summed be in B:G
Select row headers 1:100; now use Format | Conditional Formatting
In the dialog box change first thing to "Formula Is" and enter
=SUM(B1:G1)<=0; and click the Format button; make the Pattern red
best wishes


More details of Conditional Formatting at www.cpearson.com

 

[Dave Peterson]

Maybe you could use:
format|conditional formatting
and just check to see if it's less than or equal to 0.
(and give it a nice format)

 

[jbarnett]

You're genius'
Thanks again!