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