Formula help

  • Thread starter Thread starter Martin ©¿©¬
  • Start date Start date
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
 
Select your range to format and
format>conditional format>formula is
=SUM($K4,$L4,$N4)<1
format as desired
 
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'
 
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'
Click to expand...

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)
 
Back
Top