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!

[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 wrote:
>
> 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!
>
> --
> jbarnett
> ------------------------------------------------------------------------
> jbarnett's Profile: http://www.excelforum.com/member.php...o&userid=31276
> View this thread: http://www.excelforum.com/showthread...hreadid=509459

--

Dave Peterson

[Bernard Liengme]

Suppose the data is in A1:P100
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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jbarnett" <[email protected]> wrote in
message news:[email protected]...
>
> 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!
>
>
> --
> jbarnett
> ------------------------------------------------------------------------
> jbarnett's Profile:
> http://www.excelforum.com/member.php...o&userid=31276
> View this thread: http://www.excelforum.com/showthread...hreadid=509459
>

[jbarnett]

You're genius'
Thanks again!