Hey everyone,

Looking for some help

I've simplified my problem down for ease of understanding.

I have a conditional format set up that colours a range of cells (Say A2:D5) based on the value in A1. The formula reads as follows =if($a$1=1,true) for range A2:D5 and it works fabulously, especially as I want to be able to insert a column between, say, B and C, and have the cells in rows 2-5 in that column also catch the format based on the value in A1.

Problem:
Now I want to copy and paste this range (A1:D5) to E1:H5 in such a way that the conditional format for E2:H5 is determined by the value in E1 (and again over and over for multiple blocks). However when I copy and paste, the conditional format rule still refers to A1.

I tried removing the dollar signs in the rule to =if(a$1=1,true). The copy then works (as one would expect) and the E2:H5 rule refers to E1 as I hoped, but then only the cells A2:A5 (and E2:E5) change colour, as the cells in B2:D5 (and F2:H5) are looking for a similar value in B1, C1 and D1 (and F1, G1 and H1). I can't just have the same value in each of those cells (and it seems ridiculous to have to do that), because I want to be able to insert a column in any of these blocks and have the conditional format in that block catch it without having to copy and paste that number in.

I hope I've been clear enough as to the problem. Thank you in advance for any ideas anyone has.

Gavin