This required 2 rules for conditional formatting as shown in the screenshot. Make sure that the "applies to" range and the rule for conditional formatting start in the same row. In the example both start in row 2.
Select the range (the "applies to" range) you want to format with the mouse e.g. =$H$2:$I$24
Then go to:
Conditional formatting -> New rule
Use a formula to determine which cells to format
Format values where this formula is true.
Enter your formula (rule) for conditional formatting and choose the format you want to apply. Then click ok 2 times.
Thank you. It works when you remove the $ sign for the rows:
=$B2="c"
=$B2="r"
=$C2="x"
You can see how it works in the example below.
