excel-university.com
Excel Conditional Formatting Based on Another Cell
When you want to format a cell based on the value of a different cell, for example to format a report row based on a single column’s value, you can use the conditional formatting feature to c…