【Excel条件付き書式】ダウンロードデータ付（初級・中級）土日・データバー・星アイコン

[Excel Conditional Formatting Lesson 5] Filling every fifth row with a color - Using the MOD and ...

If you want to highlight cells that are in the current week, use Conditional Formatting to help out. Conditional Formatting is a general term that means cells are formatted based on certain conditions. Excel has a default setting to highlight cells based on a relative date reference. Use this if you want to highlight when invoices are coming due, like in this example. You can also create a custom formula using Conditional Formatting and the TODAY function. But the option in this video is much si

How to Create Conditional Formatting Rules in Google Sheets