New answers tagged

0

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 ...


1

Two solutions. A/ Either you do a condition for each case =A1>A2 BLUE =AND(A1>0,A1<A2) YELLOW =A1<0 RED B/ You set the cell in yellow and put only 2 condition format rules. =A1>A2 BLUE =A1<0 RED


1

=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.


1

Try REGEXMATCH : =OR(REGEXMATCH($B2,"yr"),REGEXMATCH($C2,"yr")) Second entry is a JS regular expression. You can build it with a tool like regexr.


0

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.


0

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: =EQ(CO27,LARGE(UNIQUE(CO$27:DB$27),2)) That is, the function the original poster pasted was almost correct, we just need to add the equality ...


Top 50 recent answers are included