Below is an example of a formula I created in the conditional formatting
option. I would like to copy this format across additional cells in the same
column. However, I need the row references to change automatically when
copying. Right now, if I try to Paste the cell format after copying the
cell, the row designation does not change.

=OR(AND($S$2<0.7,$C$2="male"),AND($S$2<0.6,$C$2="female"))

hi
remove the absolute refererences(dollar signs) for the row reference. it
should then paste as you want.

regards
FSt1

"Rosanne" wrote:

> Below is an example of a formula I created in the conditional formatting
> option. I would like to copy this format across additional cells in the same
> column. However, I need the row references to change automatically when
> copying. Right now, if I try to Paste the cell format after copying the
> cell, the row designation does not change.
>
> =OR(AND($S$2<0.7,$C$2="male"),AND($S$2<0.6,$C$2="female"))