Trying the regular conditional format route but that isn't working. Even adjusting for the cell locks, the fomatting formula rule remains the same when I copy the format over into each cell in the range. Why does it do that? My rule is: =ABS(C4-$Q4)>$R4
every cell in the range reads this way and for example, in cell D9, it should read: =abs(D9-$Q9)>$R9 but it remains the same as the original. is this a limitation of CF or have set the function incorrectly? I figure I could always turn this into a macro by recording the steps but i can't even get this to work correctly on its own.