Question

Conditional formatting is applied to : a) Cell Values
b) Formulas
c) Both a and b​

Answer 1

Answer:

Excel formulas for conditional formatting based on cell value

Excel's pre-defined conditional formatting rules are mainly purposed to format cells based on their own values or the values you specify. I am talking about Data Bars, Color Scales, Icon Sets and other rules available to you on the Conditional Formatting button click.

If you want to apply conditional formatting based on another cell or format the entire row based on a single cell's value, then you will need to use Excel formulas. So, let's see how you can make a rule using a formula and after that I will provide a number of formula examples for different tasks.

How to create a conditional formatting rule using a formula

To set up a conditional formatting rule based on a formula in Excel 2019, Excel 2016, Excel 2013 and Excel 2010, carry out these steps:

Select the cells you want to format. You can select one column, several columns or the entire table if you want to apply your conditional format to rows.

Tip. If you plan to add more data in the future and you want the conditional formatting rule to get applied to new entries automatically, you can either:

Convert a range of cells to a table (Insert tab > Table). In this case, the conditional formatting will be automatically applied to all new rows.

Select some empty rows below your data, say 100 blank rows.

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

Answer 2

Answer:

a) cell values

Explanation:

based on the values in the cell