Conditional Formatting Based on Another Cell - Automate Excel
https://www.automateexcel.com/conditional-formatting/based-on-another-cell/
WEBJul 30, 2023 · To highlight cells based on another cell’s value, you can create a custom formula within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule. Select Use a formula to determine which cells to format, and enter the following formula: =B4>$G$7.
DA: 40 PA: 82 MOZ Rank: 86