Excel 2007-
I have a spreadsheet that is updated frequently with new rows of data.
I have a conditional format that is set for all rows and each time I add a
new row I have to manually adjust the last row to encompass the newly added
one.
In the attached spreadsheet, new SKU data is added at the
OK, please see attachment.
zp18
On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV wrote:
> Hi ,
>
> See Below Links...
> http://www.contextures.com/xlcondformat03.html\
>
> http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html
>
> *Best Regards,*
> *Venkat *
> *Chenna
I like Dave's answer. It seems to work the best. Thanks.
On Sun, Aug 1, 2010 at 1:28 AM, Dave Bonallack wrote:
> Hi,
> Try changing the formula in M3 to:
>
> IF(COUNT(M1,M2)>0,*SUM(M1:M2)*,"")
>
> I think *M1+M2* is the problem. The '+' operand can't seem to handle
> non-numeric inputs, wherea
OK, here is an example: The whole idea is to prevent a data entry
spreadsheet having a bunch of zeroes in all the totalizing columns. Cells
K1,L1 and K2,L2 have been "Clear Contents", Cell M3 the totalizer cell is
blank. Put a 1 in K1 and the #Value error appears in M3
Cell M1: =
