In a nutshell, a conditional format changes the appearance of cells or ... rule: Select the data range, B3:E16–you want to highlight the entire row. If you use a Table, Excel will update range ...

which can be a cell reference, a value, or even an expression. Let’s try that now: Select the data range, B3:E16–you want to highlight the entire row. If you use a Table, Excel will update ...