Formula help


M

Martin ©¿©¬

Hi
Using 2007
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
 
Ad

Advertisements

D

Don Guillett

Select your range to format and
format>conditional format>formula is
=SUM($K4,$L4,$N4)<1
format as desired
 
M

Martin ©¿©¬

Thanks Don
I haven't got the hang of this yet
My columns have a header row, will that make a difference?
I have selected my range and pasted =SUM($K4,$L4,$N4)<1 into the
formula bar but nothing happens
What do you mean by 'format as desired'
 
Ad

Advertisements

D

Don Guillett

Thanks Don
I haven't got the hang of this yet
My columns have a  header row, will that make a difference?
I have selected my range and pasted =SUM($K4,$L4,$N4)<1 into the
formula bar but nothing happens
What do you mean by 'format as desired'

Pls go back and read my comments again. You use the formula in the
conditional formatting. If, after you try, send to me with details
(e-mail address removed)
 

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