0
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.
Wiki User
∙ 9y ago
Wiki User
∙ 14y agoHighlight 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.
Add your answer:
Earn +20 pts
Does Excel have two types of conditional formatting?
You do Conditional Formatting based on a cell value or based on a formula.
Which Excel feature would allow you to change the font and color of a cell based on its value?
Conditional Formatting.
What cell in excel with a numerical value of zero?
Blank Cell
What cell in Excel has a numerical value of zero?
A cell with zero in it, a cell that is blank and a cell that has the logical value FALSE in it will all have the numerical value zero.
In excel if value is in one column automaticlly put formula in another column?
There is no way to have a value in one cell put a formula in another cell. However, you can put a formula in a cell that will change, based on the value of another cell. If you put the formula =A1 in cell B1, B1 will display the value of whatever you place in cell A1.
What is a pv cell?
PV is a function in Excel for returning the present value of an investment based on a constant interest rate and payment schedule.
Does a blank cell in Excel have a numerical value of negative one?
No. It has a value of zero.
In excel what contains the numerical value of zero?
Blank Cell.
A 1 in Microsoft Excel is?
A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.
What is a cell and it's importance to Excel?
A cell is the location that hold individual data items. Excel would be of no value it there was no way to store data in the program.
How do you format an absolute value in Excel?
In excel cell, type =ABS(XXXX). It will return the absolute value of the number or equation you put within the parentheses.
A numeric value that originates in a excel worksheet cell is called a data?
A worksheet cell with a numeric value is called a data point.
