# Formula Help

M

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

Thank you

C

#### Claus Busch

hi 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

hi 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,

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

Hi 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,

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!191

Regards
Claus Busch

C

#### Claus Busch

Hi 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

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)