I am setting conditional formatting on a rather large spreadsheet for sum
values by month.

Cell A1 is the Resired resource request (data input)
Cell A2 =Sum(A3:A5)
Cell A3 through A5 are data input fields.

I can set conditional formatting to change fill based on greater than/less
than. What I cannot do is perform a bulk operation that will change my
conditional value for columns B through AH. Copy/paste special...formats
will add the conditional format, but KEEP the original reference.

Any way to change the in the same fashion as a traditional formula does when
you copy/paste?

Cheers....