Conditional color formatting with custom formulas in Sheets
Question (from Shane W):
How to apply conditional formatting based on a match from one column to a range of values in another tab?
Example formula (entered within the custom formula menu):
=match($F12, indirect("'rangeTab'!$B$12:$B") ,0)
See a full example here:
https://docs.google.com/spreadsheets/...
Or grab all our Sheets formula templates from the CIFL Vault:
https://trello.com/b/5GKC0GLY/coding-...