Formula Help

M

Martin ©¿©¬

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
 
C

Claus Busch

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
 
M

Martin ©¿©¬

hi Martin,

Am Mon, 13 May 2013 19:32:10 +0100 schrieb Martin ©¿©¬:


select your table => conditional Formatting => Formula:
=SUM($K1,$L1,$N1)=0


Regards

Thanks Claus,
When I click conditional formatting there is no 'formula' option?
 
C

Claus Busch

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
 
M

Martin ©¿©¬

Hi Martin,

Am Tue, 14 May 2013 16:56:56 +0100 schrieb Martin ©¿©¬:


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)
 
C

Claus Busch

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!191
for the file "Martin" and right-click and download it.


Regards
Claus Busch
 
C

Claus Busch

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
 
Z

zvkmpw

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)
 
M

Martin ©¿©¬

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top