Hi, what I want is to change the color of a range of cells based on 10 different criteria, the problem I have is that I also need to copy and past these (and on occation remove the cells) as the sheet is updated.
I know that this could probably be done with VBA, but will it copy
say for example, if cell a1:a10 have the coding so they change red if A1 = 1 and then I copied A1:a10 and pasted them in to B1:B10 will B1 change red if B1=1? this is what I wanted it to do.
Is there a way that I can determine the cell colour within an 'IF' statement?
I know that this could probably be done with VBA, but will it copy
say for example, if cell a1:a10 have the coding so they change red if A1 = 1 and then I copied A1:a10 and pasted them in to B1:B10 will B1 change red if B1=1? this is what I wanted it to do.
Is there a way that I can determine the cell colour within an 'IF' statement?