copy conditional formatting across all cells in column
 

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="f emale"))

copy conditional formatting across all cells in column
 

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="f emale"))