MAX formula in Conditional Formatting to highlight the largest value from four separate cells?

[arthurz11]

 

[hagia_sofia]

Hello, based on the picture it could be:

=MAX($A$1:$C$3)=A1

 

[arthurz11]

I have other values between the cells. I just didn't type it knowing a range would be used. I would like to highlight the max value from only using the cells A1, A2, B1, and B2 without using a range. The real data is that the cells are like 20 cells apart, with values, empty spaces, and texts in between the cells. Can it be done?

 

[arthurz11]

Hello, based on the picture it could be:

=MAX($A$1:$C$3)=A1

Corrections: I have other values between the cells. I just didn't type it knowing a range would be used. I would like to highlight the max value from only using the cells A1, A3, C1, and C3 without using a range. The real data is that the cells are like 20 cells apart, with values, empty spaces, and texts in between the cells. Can it be done?

 

[hagia_sofia]

If it is just about 4 values:

=MAX($A$1;$C$1;$A$3;$C$3)=A1

 

[arthurz11]

It didn't work with the semicolon. So I removed the semicolon and replaced it with commas. It work perfect!!! Thank you so much!!!

 

[hagia_sofia]

Ah, indeed, sorry about that, you are right...