Question

………………………….. lets us format cells based on a specific condition.
(excel)
pls answer​

Answer 1

Answer:

$\star\:\:\bf\large\underline\blue{Question:-}$⋆

Question:−

Simplify the problem.

$\star\:\:\bf\large\underline\blue{Solution:-}$⋆

Solution:−

$\sqrt{a + b + 2x + 2 \sqrt{ab + (a + b)x + {x}^{2} } }$

Now, let

y = $\sqrt{ab + (a + b)x + {x}^{2} }$y=

Therefore,

$\sqrt{a + b + 2x + 2 \sqrt{ab + (a + b)x + {x}^{2} } }$

= $\sqrt{a + b + 2x + 2 + 2 \sqrt{y} }$=

Now, we will factorise y.

$\sqrt{ab + (a + b)x + {x}^{2} }$

= $\sqrt{ab + ax + bx + {x}^{2} }$=

= $\sqrt{a(b + x) +x(b+ x)}$=

= $\sqrt{(x + a)(x + b)}$=

Now,

= $\sqrt{a + b + 2x + 2 + 2 \sqrt{y} }$=

= $\small\sqrt{(x + a) + (x + b) + 2 \sqrt{(x + a)(x + b)} }$=

= $\sqrt{ {( \sqrt{x + a}) }^{2} + {( \sqrt{(x + b} )}^{2} + 2 \times \sqrt{(x + a} \times \sqrt{(x + b)} }$=

= $\sqrt{ {( \sqrt{x + a} + \sqrt{x + b} )}^{2} }$=

= $\sqrt{x + a} + \sqrt{x + b}$=

$\star\:\:\bf\large\underline\blue{Answer:-}$⋆

$\sqrt{x + a } + \sqrt{x + b}$

Answer 2

Answer:

Explanation:

Excel formulas for conditional formatting based on cell value

Select the cells you want to format. ...

On the Home tab, in the Styles group, click Conditional formatting > New Rule…

In the New Formatting Rule window, select Use a formula to determine which cells to format.

Enter the formula in the corresponding box.