Use conditional formatting to highlight information in Excel
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-in-excel-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
WEBTo add a new conditional format based on one that is already listed, select the rule, then click Duplicate Rule. The duplicate rule is copied and appears in the dialog box. ... When rules don't conflict For example, if one rule formats a cell with a bold font and another rule formats the same cell with a red color, the cell is formatted with ...
DA: 29 PA: 37 MOZ Rank: 86