Thread
: [Solved]
Code for Changing Cell Backgrounds
View Single Post
12-05-2008, 02:03 AM
et5323
Novice
Join Date: Dec 2008
Posts: 1
Reference:
sub test()
dim rng as range
for each rng in range("a1:a5")
with rng
if .value>.offset(0,1).value then
.interior.colorindex = 3
else
.interior.colorindex = 4
end if
end with
next
end sub
et5323
View Public Profile
Find all posts by et5323