New answers tagged conditional-formatting
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
