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