I have the following condition for formatting a range of cells (turning them red): =AND(BE314="S",BS314=5), and the range of cells I'm trying to format is: =$BW$314:$CC$332

If I write the condition using $ signs like this: =AND($BE$314="S",$BS$314=5), the formatting of $BW$314:$CC$332 works fine, but as soon as I remove the $ signs and write it like this =AND(BE314="S",BS314=5), only cell BW314 is formatted, and the rest of the range is not. I'd like to leave the $ signs off b/c I need to paste this formatting to multiple areas in the workbook, and have it be depended not on =AND($BE$314="S",$BS$314=5), but whatever row and column this condition ends up in when I copy and paste the range of cells I am formatting.

So for example, if I copy $BW$314:$CC$332 that has been conditionally formatted and paste it 100 rows down to $BW$414:$CC$432, I'd like the condition to automatically be AND(BE414="S",BS414=5) without me having to go in and changing where that condition is located.

Is this possible to do?