Highlight values which appear in a row and two columns (Google Sheets)

[asolopreneur]

I am creating a bubble chart and I don't want to overlap two bubbles. I can avoid it, if two values appear in the same row and two columns gets highlighted. (I am using Google Sheets.)

 

[Fluff]

Don't know much about sheets, but if you use this formula in the conditional formatting, it should work

=$B2=$C2

If the columns you want to highlight are not b & C change the ranges accordingly.

 

[asolopreneur]

Don't know much about sheets, but if you use this formula in the conditional formatting, it should work

=$B2=$C2

If the columns you want to highlight are not b & C change the ranges accordingly.

If the same value appears in two columns, it's also getting highlighted. I don't want this.

 

[asolopreneur]

Don't know much about sheets, but if you use this formula in the conditional formatting, it should work

=$B2=$C2

If the columns you want to highlight are not b & C change the ranges accor

Fixed with two helper columns,

Here is how,

 

[Fluff]

Glad you sorted it & thanks for the feedback.