Formula Help
 

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
©¿©¬

Formula Help
 

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

Formula Help
 

On Mon, 13 May 2013 20:42:45 +0200, Claus Busch
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,
When I click conditional formatting there is no 'formula' option?
--
Nitram
©¿©¬

Formula Help
 

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 Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Formula Help
 

On Tue, 14 May 2013 18:07:50 +0200, Claus Busch
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
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
©¿©¬

Formula Help
 

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 he
https://skydrive.live.com/#cid=9378A...121822A3%21191
for the file "Martin" and right-click and download it.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Formula Help
 

On Wed, 15 May 2013 16:29:09 +0200, Claus Busch
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 he
https://skydrive.live.com/#cid=9378A...121822A3%21191
for the file "Martin" and right-click and download it.


Regards

Then what do I do?

Formula Help
 

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.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Formula Help
 

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)

Formula Help
 

On Wed, 15 May 2013 17:13:00 -0700 (PDT), zvkmpw
wrote:

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)

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