2つの列に同じ値がある場合に条件付き書式を設定する。Excelマジックトリック1704。
Shortcut to Replace background color #excelshorts
Highlight cells containing a Specific Text or Number
Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting
Cell Text Color Change trick in Excel
Excel Conditional Formatting based on Another Cell | Highlight Cells
Find duplicates from two separate lists in Excel with Conditional Formatting! #excel #exceltips
IF Statement in Excel Based On Cell Color - Excel Formula
Using If then statement to change cell fill color (sort of)
How to Change Cell Color Based on Date Using Excel Formula
Excel Conditional Formatting with Formula | Highlight Rows based on a cell value
Excel: 別のセルの値に基づいてセルの色を変更する
How to Count Colored Cells in Excel (Three Ways!)
How to Change Cell Color Automatically Based on Value in Microsoft Excel
Nested If Function,,,#excel
Colour match each duplicate with Excel's conditional formatting
Excel COUNTIF & SUMIF の色指定 - VBA 不要
Excelの条件付き書式|条件に基づいて色を変更する方法
SUM Cells by Color in Excel