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