New answers tagged

0 votes
Accepted

Conditional formatting based on data lookup and comparison

Put this formula in Lookup!A20 and copy to the right: =textjoin("→", true, A3:A17) Then use this conditional formatting custom formula rule for the range Roster!B3:F: =len(B3) * search(...
doubleunary's user avatar
0 votes
Accepted

What is wrong with my Conditional Formatting Formula?

Syntax Error INDIRECT takes a reference-as-string or a reference to a cell that contains a reference-as-string, but you are passing it a range reference. You need to add quotation marks to convert the ...
Blindspots's user avatar
  • 4,269
0 votes

Conditional format google sheets cells based on preceding cells

Custom Formula =AND(C1=B1, C1=A1, C1<>"") Based on a range that starts with C1. Some examples of valid ranges for that formula are C:Z, C1:Z1, C1:G40, etc. Why C1? No reason other ...
Blindspots's user avatar
  • 4,269

Top 50 recent answers are included