Google Sheets
=GOOGLE(...)Google Sheets Duration Over 24 Hours: Use [h]:mm
Show Google Sheets durations over 24 hours with elapsed-time formats, numeric conversions, and reliable formulas.
Explore ↗
Formatting & Layout
4 formula guides
Google Sheets
=MOD(ROW(),2)=0Google Sheets Conditional Formatting: Rules & Custom Formulas
Master conditional formatting in Google Sheets: preset rules, color scales and custom formulas for highlighting data.
Explore ↗
Excel
=EXCEL(...)Excel Custom Number Formats: Format Codes, Colors & Conditions
Learn Excel custom number format codes: four-section structure, colors, conditions, and thousands scaling with examples.
Explore ↗
Excel
=MOD(ROW(),2)=0Conditional Formatting in Excel: Complete Visual Guide
Learn conditional formatting in Excel. Highlight cells, color scales, data bars, and custom rules step by step.
Explore ↗