Format Cells based on a letter in other cells

Jeremy - Jan 3, 2012 at 10:11 AM
Sorry I'm new at Excel, but here is what I'm trying to do:

I'm making a work schedule.
3C through 3AG represent the days of the week.
I currently have them formatted to turn orange when there is a "S" (weekend) entered into the columns.

I now need the following columns to turn orange as well based on that "S" being placed in any section of 3B through 3AG.

5C to 15AG

Any thoughts on how I could do this?