How do you shade a row based on one cell value in Excel?

Answer 1

You need to use Conditional Formatting to do that. You need to set a formula option within Conditional Formatting for the cells that look at one particular cell's value. Conditional Formatting has the option to set formatting based on values or based on formulas. In this instance you would need a formula. For example you could have a formula like this, which checks if cell A2 is greater than 10:=$A$2>10Then you can set whatever formatting you want.

Answer 2

Highlight the row and use conditional formatting. Select formula and enter the criteria you want to evaluate, then select the color you want to use for shading.