change background color

Yes, you can do this automatically using Conditional Formatting with a formula. Here's how to set it up:

Steps to create the automatic color change:

Select the range you want to format:

Click and drag to select B9:F550

Open Conditional Formatting:

Go to the Home tab

Click Conditional Formatting > New Rule

Choose rule type:

Select "Use a formula to determine which cells to format"

Enter the formula:

=OR($B9="S",$B9="P")

(Note the $ before B - this locks column B but allows the row to change)

Set the formatting:

Click the Format button

Go to the Fill tab

Choose White

Click OK

Apply the rule:

Click OK to close the New Rule dialog

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.