how to copy a cell that has been conditionally formatted

**Dexter Stagg** · 12-27-2012, 01:57 PM

Hi, please can anyone tell me how to copy a cell that has been conditionally formatted ? each cell reacts to 10 other cells in the same column at the top of the page. there are 200 cells at the bottom of the column which i need to format, but if i drag down, copy and paste or use the format brush, the 200 cells react with each other instead of remaining seperate and individually reacting with the 10 cells at the top of the column.

**Dexter Stagg** · 12-27-2012, 01:59 PM

i can format them individually but need to repeat this over 20 columns making a total of 4000 cells

**Ace_XL** · 12-27-2012, 02:12 PM

Ensure that your CF rules uses thje absolute referncing of cells

e.g.
Instead of
=A1="Full"
use
=A$1="Full"
or
=$A$1="Full"

You could then use the fomat painter.

Does this help?

**Dexter Stagg** · 12-27-2012, 04:32 PM

The cf rules uses this one =$A$1="Full" , but when i use the format painter it includes the copied cell in the format instead of keeping the new cell as a seperate formula. it is quite hard to explain. thanks phil