Advanced Conditional Formatting - Google Sheets - Use Formulas, Cell References
Learn how to apply advanced conditional formatting in Google Sheets using formulas. We'll create logical test formulas to apply conditional formatting, sample cases with cell references, highlighting the entire row, references to other worksheets, highlighting duplicates & extra duplicates, highlighting rows that appear on a list in a different worksheet. and more.
INDIRECT
IF, IFS
IF, AND, OR
