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
https://www.youtube.com/watch?v=Vuh7lh2mhQk

IF, IFS
https://www.youtube.com/watch?v=hG5vKMb0Lpo

IF, AND, OR
https://www.youtube.com/watch?v=ihpeWzWBjDU

#googlesheets #conditionalformatting #advanced