Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Formula Help
6 views
Skip to first unread message
Martin ����
May 13, 2013, 2:32:10 PM5/13/13
to
Hi
Using 2010
I have a spreadsheet with 276 rows (can be variable)
In columns K,L & N, �I have financial amounts some of which are zero
or blank.
What I would like to do is when K,L & N are all zero or blank in the
same row is to highlight this row in colour so that it is easily
recognised
Anyone help please
Thank you
--
Nitram
����
Using 2010
I have a spreadsheet with 276 rows (can be variable)
In columns K,L & N, �I have financial amounts some of which are zero
or blank.
What I would like to do is when K,L & N are all zero or blank in the
same row is to highlight this row in colour so that it is easily
recognised
Anyone help please
Thank you
--
Nitram
����
Claus Busch
May 13, 2013, 2:42:45 PM5/13/13
to
hi Martin,
Am Mon, 13 May 2013 19:32:10 +0100 schrieb Martin ����:
> I have a spreadsheet with 276 rows (can be variable)
> In columns K,L & N, �I have financial amounts some of which are zero
> or blank.
> What I would like to do is when K,L & N are all zero or blank in the
> same row is to highlight this row in colour so that it is easily
> recognised
select your table => conditional Formatting => Formula:
=SUM($K1,$L1,$N1)=0
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Am Mon, 13 May 2013 19:32:10 +0100 schrieb Martin ����:
> I have a spreadsheet with 276 rows (can be variable)
> In columns K,L & N, �I have financial amounts some of which are zero
> or blank.
> What I would like to do is when K,L & N are all zero or blank in the
> same row is to highlight this row in colour so that it is easily
> recognised
=SUM($K1,$L1,$N1)=0
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Martin ����
May 14, 2013, 11:56:56 AM5/14/13
to
On Mon, 13 May 2013 20:42:45 +0200, Claus Busch
<claus...@t-online.de> wrote:
>hi Martin,
>
>Am Mon, 13 May 2013 19:32:10 +0100 schrieb Martin ����:
>
>> I have a spreadsheet with 276 rows (can be variable)
>> In columns K,L & N, �I have financial amounts some of which are zero
>> or blank.
>> What I would like to do is when K,L & N are all zero or blank in the
>> same row is to highlight this row in colour so that it is easily
>> recognised
>
>select your table => conditional Formatting => Formula:
>=SUM($K1,$L1,$N1)=0
>
>
>Regards
Thanks Claus,
<claus...@t-online.de> wrote:
>hi Martin,
>
>Am Mon, 13 May 2013 19:32:10 +0100 schrieb Martin ����:
>
>> I have a spreadsheet with 276 rows (can be variable)
>> In columns K,L & N, �I have financial amounts some of which are zero
>> or blank.
>> What I would like to do is when K,L & N are all zero or blank in the
>> same row is to highlight this row in colour so that it is easily
>> recognised
>
>select your table => conditional Formatting => Formula:
>=SUM($K1,$L1,$N1)=0
>
>
>Regards
When I click conditional formatting there is no 'formula' option?
--
Nitram
����
Claus Busch
May 14, 2013, 12:07:50 PM5/14/13
to
Hi Martin,
Am Tue, 14 May 2013 16:56:56 +0100 schrieb Martin ����:
> When I click conditional formatting there is no 'formula' option?
Conditional Formatting => New Rule => Use a *formula* to determine which
cells to format
Am Tue, 14 May 2013 16:56:56 +0100 schrieb Martin ����:
> When I click conditional formatting there is no 'formula' option?
cells to format
Martin ����
May 15, 2013, 10:17:26 AM5/15/13
to
On Tue, 14 May 2013 18:07:50 +0200, Claus Busch
<claus...@t-online.de> wrote:
>Hi Martin,
>
>Am Tue, 14 May 2013 16:56:56 +0100 schrieb Martin ����:
>
>> When I click conditional formatting there is no 'formula' option?
>
>Conditional Formatting => New Rule => Use a *formula* to determine which
>cells to format
>
>
>Regards
Claus, formula hits some lines , misses others & highlights some lines
<claus...@t-online.de> wrote:
>Hi Martin,
>
>Am Tue, 14 May 2013 16:56:56 +0100 schrieb Martin ����:
>
>> When I click conditional formatting there is no 'formula' option?
>
>Conditional Formatting => New Rule => Use a *formula* to determine which
>cells to format
>
>
>Regards
with numbers in them
I checked that the column names are K, L & N against the formula
=SUM($K1,$L1,$N1)=0 - so I'm really puzzled as to what's wrong
My spreadsheet has columns from left to right
A, B E, K, L & N. as I removed some unnecessary columns
Perhaps that's what's messing things up? (only guessing)
--
Nitram
����
Claus Busch
May 15, 2013, 10:29:09 AM5/15/13
to
Hi Martin,
Am Wed, 15 May 2013 15:17:26 +0100 schrieb Martin ����:
> Claus, formula hits some lines , misses others & highlights some lines
> with numbers in them
> I checked that the column names are K, L & N against the formula
> =SUM($K1,$L1,$N1)=0 - so I'm really puzzled as to what's wrong
please look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3%21191
for the file "Martin" and right-click and download it.
Am Wed, 15 May 2013 15:17:26 +0100 schrieb Martin ����:
> Claus, formula hits some lines , misses others & highlights some lines
> with numbers in them
> I checked that the column names are K, L & N against the formula
> =SUM($K1,$L1,$N1)=0 - so I'm really puzzled as to what's wrong
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3%21191
for the file "Martin" and right-click and download it.
Martin ����
May 15, 2013, 10:56:48 AM5/15/13
to
On Wed, 15 May 2013 16:29:09 +0200, Claus Busch
<claus...@t-online.de> wrote:
>Hi Martin,
>
>Am Wed, 15 May 2013 15:17:26 +0100 schrieb Martin ����:
>
>> Claus, formula hits some lines , misses others & highlights some lines
>> with numbers in them
>> I checked that the column names are K, L & N against the formula
>> =SUM($K1,$L1,$N1)=0 - so I'm really puzzled as to what's wrong
>
>please look here:
>https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3%21191
>for the file "Martin" and right-click and download it.
>
>Regards
Then what do I do?
<claus...@t-online.de> wrote:
>Hi Martin,
>
>Am Wed, 15 May 2013 15:17:26 +0100 schrieb Martin ����:
>
>> Claus, formula hits some lines , misses others & highlights some lines
>> with numbers in them
>> I checked that the column names are K, L & N against the formula
>> =SUM($K1,$L1,$N1)=0 - so I'm really puzzled as to what's wrong
>
>please look here:
>https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3%21191
>for the file "Martin" and right-click and download it.
>
>Regards
Claus Busch
May 15, 2013, 11:10:29 AM5/15/13
to
Hi Martin,
Am Wed, 15 May 2013 15:56:48 +0100 schrieb Martin ����:
> Then what do I do?
compare your conditional formatting with mine and find the error.
Or paste your data in my workbook and look if the conditional formatting
is correct.
Am Wed, 15 May 2013 15:56:48 +0100 schrieb Martin ����:
> Then what do I do?
Or paste your data in my workbook and look if the conditional formatting
is correct.
zvkmpw
May 15, 2013, 8:13:00 PM5/15/13
to
On a related note, can the "financial amounts" be sometimes negative?
If so, then the sum might be zero by combining a positive with a negative.
So perhaps consider a conditional formula like:
=AND(K1=0,L1=0,N1=0)
If so, then the sum might be zero by combining a positive with a negative.
So perhaps consider a conditional formula like:
=AND(K1=0,L1=0,N1=0)
Martin ����
May 20, 2013, 12:26:16 PM5/20/13
to
On Wed, 15 May 2013 17:13:00 -0700 (PDT), zvkmpw <zvk...@comcast.net>
wrote:
Thanks for your reply
There are no zeros anywhere in the spreadsheet, I looking for a line
of 3 Zeros in adjacent colums K, L & N
wrote:
There are no zeros anywhere in the spreadsheet, I looking for a line
of 3 Zeros in adjacent colums K, L & N
0 new messages