=A2>$B$1
=MOD(ROW(),2)=0
=COUNTIF($A$1:$A$100,A1)>1
=OR(TEXT(A2,"DDD")="Sat", TEXT(A2,"DDD")="Sun")
Excel Conditional Formatting, Excel Formulas, Advanced Excel Tips, Data Visualization Excel, Professional Excel Formatting, Conditional Formatting Tricks, Excel Spreadsheet Design, Mastering Excel Techniques