Conditional formatting 2 cells in case of an abbreviation

[Berna11]

Good morning, in the attached file I have a format that turns me yellow in case there are 2 full cells out of 3.
I would like to change it so that if there is an R in the third column, the yellow color does not apply but both remain gray.

Example B22-D22 both gray.
Also F30: G30 = gray.
B12: C12 are fine.

Thank you

[Sunny18pc]

Hi,
Just like to inquire the value that you are using in D22 as "R" but when I checked it was "R " there was an extra space.
Do you need than space or I shall trim that value.

[Berna11]

Thank you,
okay without the space..excuse the error.

[Berna11]

Good evening I send the correct file
I removed the formulas from the formatting they were incorrect
* and I manually entered the desired result in column B-C-D

Every 3 columns are part of a person.

Yellow color only if column B-C are full, all the rest gray.
If column C-D are full gray because in the cover D is always and only the R and, when the R is always gray.
I hope it is clearer.
Thank you

[Berna11]

Good evening I try to explain better.
formatting must be applied on 3 columns at a time B-C-D;
E-F-G etx..etc ..

I need to color it yellow when the initials M and P are in row 3 and the cells in the rows below are both full.
Then column B-C or E-F .... full
All remaining full cells color gray.

[Root_]

See if the following CF rules, applied to range B5:AH33, work for you:

yellow fill, stop if true
=OR(AND(B5<>"",C5<>"",INDEX($3:$3,COLUMN(B5))="M",INDEX($3:$3,COLUMN(C5))="P"),AND(A5<>"",B5<>"",INDEX($3:$3,COLUMN(A5))="M",INDEX($3:$3,COLUMN(B5))="P"))

gray fill, stop if true
=B5<>""

[Berna11]

Perfect thanks it works
thanks to the next hello