answersLogoWhite

0

Use Go to Special and choose conditional formats

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is it calledwhen you click into a cell and gets highlighted?

You could call it highlighting but more commonly you would call it selecting.


Can an Excel user paste a range of cells in the same worksheet the cells were copied?

Yes. You simply copy the cells, then highlight the upper left most cell of the desired destination (do not highlight multiple cells) and then paste.


How do you copy a cell to a range of cells. For example copy a value in A1 from A2 - A2000?

By Copy and Paste If you highlight the cells which need the same value, copy from Cell (A1) and then highlight all the cells which need the same value and Click paste Voila!


What is unprotected cell in Excel?

It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.It is possible to lock cells so they cannot be changed, so an unprotected cell is not like that and can be changed. Cells can be locked and when protection is applied only unprotected cells can be changed.


What provides a visual cue about the value of a cell relative to other cells in excel?

There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.There are various answers to that. It could be a part of a chart, and the value in a cell may be shown in relation to other cells on whichever chart it is on. Another way is conditional formatting which could be done in such a way to highlight a particular cell in some way. So you could have the highest value cell highlighted or a cell holding today's date highlighted, or whatever you want, depending on the situation you are in.


What is a cell highlighted with a dark border?

Usually that indicates the active cell, but you can also have a selection of cells or have cells that have had borders applied to them.


What is A word or a phrase applied to a cell or range of cells is called?

name


Why do all cells need a cell membrane?

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells


Can format be applied between cells?

Format is applied to cells and ranges of cells. The only formatting between cells actually is to format the cell border, since all adjacent cells share the same borders with the cells they touch.


Who applied the cell theory to plants?

Matthias Schleiden, a German botanist, applied the cell theory to plants in 1838. He proposed that plants are made up of cells and that these cells are the basic unit of structure and function in plants.


What word describes a format such as cell shading that is applied to cells when a specific condition applies?

Conditional


What cell contains the greatest number of unipotent stem cells?

The adult organisms contains the greatest number of unipotent stem cells. It is a term that is usually applied to a cell in adult organisms.Ê