View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
redf1re[_8_] redf1re[_8_] is offline
external usenet poster
 
Posts: 1
Default comparing and painting cells


geez.... my spaces went to hell

For each cell in the range(E:Q) do
if cell value = 0 then
.........paint the cell white
else if cell in the first column is 1 then
...........paint the cell blue
else if cell in the first column is 2
...........if cell value is less than or equal to the cell in the
previus row and same column
.......................paint the cell green
...........else if value is greater than the cell in the previus row
and same column
........................paint the cell red
next cell


--
redf1re
------------------------------------------------------------------------
redf1re's Profile: http://www.excelforum.com/member.php...o&userid=31258
View this thread: http://www.excelforum.com/showthread...hreadid=511141