Format Cells based on a letter in other cells [Closed]

Report
-
Hello,
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?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!