Conditional Formatting
- Select the range A1:A10.
- On the Home tab, in the Styles group, click Conditional Formatting.
- Click Highlight Cells Rules, Greater Than.
- Enter the value 80 and select a formatting style.
- Click OK. Result. Excel highlights the cells that are greater than 80.
- Change the value of cell A1 to 81.
Can I use an IF formula in conditional formatting?
The answer is yes and no. Any conditional formatting argument must generate a TRUE result, meaning that at a literal level, your conditional formatting rule is an If/Then statement along the lines of “If this condition is TRUE, THEN format the cell this way”.
How do I apply conditional formatting to an entire row based on one cell?
Re: Conditional formatting for entire row based on data in one cell
- Select any cell in row 1.
- Go to 'Conditional Formatting>New Rule>Use a formula to determine which cells to format'
- In the formula field paste =$D1="Shipped", set the required format and click 'OK'
