Hi,
I'm trying to set conditional formatting in B4 and then copy it down the column but I want the cell reference to change. It seems to stay the same. I'm not sure if it is to do with the cells I'm referencing. The formula i've included is. So i would like it to change to B6 & C6 but N3 to stay the same.The cell I'm trying to use the conditional formatting on holds an array formula so I'm not sure if that is an issue.Please Login or Register to view this content.
I've attached the file.
Bookmarks