With the range e2:e30 selected, create a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values that sold for less than or equal to 70% of the sticker price. be sure to select a rule type that will use a formula to determine which cells to format. 5

Respuesta :

What is layout rule in Excel?

In a comparable fashion, you may create a conditional formatting rule to examine the values of  cells. For example: =$A2<$B2 - layout cells or rows if a fee in column A is much less than the corresponding fee in column B. =$A2=$B2 - layout cells or rows if values in columns A and B are the same.

The process of a new conditional formatting rule that uses a formula to apply yellow fill and bold font to values is given in the picture attached.

Read more about the formatting :

https://brainly.com/question/3653791

#SPJ1

                                                                                 

Ver imagen saimaparvezVT