Hi doudou,

You don't really need programming for this you can use Conditional Formatting
http://www.mvps.org/dmcritchie/excel/excel.htm

If you really mean any cell on the row select the entire worksheet
with cell A1 active
=A1<0

If you mean column F then
=$F1<0

If you mean Columns C:F then
=MIN($C1:$F1)<0

If you want a programming solution then you are looking for
something along the lines of
cell.ENTIREROW.interior.colorindex = 3
or possibly
cell.ENTIREROW.font.colorindex = 3
http://www.mvps.org/dmcritchie/excel/colors.htm
and possibly in a Change Event macro
http://www.mvps.org/dmcritchie/excel/event.htm#case
with a change similar to the above.

Your question is answered in the microsoft.public.excel.programming
newsgroups has and nothing whatsoever to do with excelforum.com
except that such postings mess up web searches by including
newsgroup postings.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"doudou" wrote in message
...

hi, is it possible to put a all row in red when one of its cell has a
negative amount ?
thx


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php...o&userid=24047
View this thread: http://www.excelforum.com/showthread...hreadid=399294