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"))