This should work. Using $G1 in your conditional format will allow you
to drag the formula accross columns or vertically down rows keeping
column G as the reference column and only changing the row number as it
is copied down. Not sure without seeing an example of what you are
trying to accomplish though.


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=499544