if amount <0, put the all line in red

Tech-Archive recommends: Fix windows errors by optimizing your registry


Hi,

is it possible to do that: change color of the all row when one of its
cell contains a negative amount ?

thx


--
doudou
------------------------------------------------------------------------
doudou's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24047
View this thread: http://www.excelforum.com/showthread.php?threadid=399280

.

Relevant Pages

  • red row
    ... doudou's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24047 ...
    (microsoft.public.excel.programming)
  • RE: comment enclosed using vlookup
    ... Many thx cause it works! ... "Jacob Skaria" wrote: ... present for Col C the function will return the comments to the formula cell. ... rngLookUpArray As Range, intColumn As Integer) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to copy a cell and horizontally expand the paste along hea
    ... Thx for the reply. ... the first column is filled in on 10 rows high; ... Double-click on the black bold cross in the lower-right of this cell. ...
    (microsoft.public.excel.misc)
  • Re: Protecting data validation Drop DownColumn
    ... thx. ... I want to build a template kind of sheet with couple of drop down columns ... With cell A1 having the Data Validation ... Protect the sheet ...
    (microsoft.public.excel)
  • Re: Have row color change to one of 8 different colors based on one ce
    ... regardless if the letter is 'cap' or 'lower case'? ... Private Sub Worksheet_Change ... One thing I did notice is that when I type in the cell value in column ... thx again. ...
    (microsoft.public.excel.misc)