Google Sheets doesn't have a built-in function that directly returns something to tell us if a cell is merged or not. Perhaps the closer function is CELL(info_type, reference) with the first parameter specifying the type of information that should be returned. Unfortunately it doesn't include an "info_type" for merged/un-merged.
On the other hand, it's a ...
=OR(D$2="Sat",D$2="Sun") is the custom formula I use to change column colour if the header (line 2 in the sheet) is Sat or Sun.
To use a full word, just type it inside the quotation marks.
The dollar sign $ locks the formula to row 2 over the range. So if you put the Dollar Sign $ in front of the column letter, it will check the column instead of the row.
Go to the menu: Format -> Conditional formatting.
Specify the range to be applied the rule on the "Apply to range" field, in your case A3:H3
On format rule select Custom formula is
Write the formula: =AND($B3=TRUE, $C3=TRUE, $D3=TRUE, $E3=TRUE, $F3=TRUE, $G3=TRUE)
Select the formatting style: the color background.
Just to make this question finally answered the way original poster wants it to be:
To get the second largest value(s) in the set of values on a range of sheet, ignoring duplicate values.
You can use this formula:
That is, the function the original poster pasted was almost correct, we just need to add the equality ...