answersLogoWhite

0

You need to use Conditional Formatting.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How can excel change values affect business decisions?

Excel allows you to change values in a worksheet quickly and easily. How is this helpful in running a business? How can changing values affect business decisions?


What is transpose in ms exel?

Transpose means to change places. In Excel Transpose will change the orientation of a block of cells. So a list of cells across a row can be changed to be in a column, and a list of cells in a column can be changed to be in row. A table of cells can all be changed to having the values in the rows being in columns and the values in the columns being changed to rows.


When you change the color of the fill in a cell in excel you are changing its?

When you change the color of the fill in a cell you are changing its format. This action applies to Microsoft Excel.


What should the Save As file type be if saving Excel?

That will depend on what you want to do. If you are in Excel saving as a standard Excel file, you don't need to change the file type. It is only if you want to save into a different format, that you would change the File Type. What you change it to, would depend on what you need. You might want to change to a different version of Excel or maybe into a completely different format, such as a text file. If you are working in a different application, saving something to be used in Excel, then again it will depend on what format you actually need.


What allows you to use Excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values?

The ___________ allows you to use excel to change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values.


Can default settings be changed for printing a Excel worksheet?

Default settings can be changed for anything, so yes you can change them when you are printing a worksheet in Excel.


The default format for a number typed into Excel is the format?

All numbers in Excel are actually decimal values (stored at the lowest level). The default is a best guess of how you typed it. Dates, numbers, etc. Remember - The format doesn't mean much of anything.. what's stored there remains the same.


What format is Excel in?

MS Excel 2003 and earlier use the XLS format. MS Excel 2007 and later use the XLSX format.


How do you change the entry to currency in Microsoft Excel?

Right-click on the cell or range of cells you want to change and click on cell format. From the cell format window, select a number format of currency.


How can I convert PDF to excel for free?

Well, I would recommend converting PDF format files to excel format files with a PDF format file to excel format file converter. There are many PDF format file to excel format file converters offered for use.


Does Excel automatically recalculate all cells values?

If autocalculate is turned on (default setting), Excel will automatically recalculate all cell values in real time any time a referenced cell is changed.


How will excel 2007 format cells containing values that fall in the lowest 10 and that are lower than 5000?

With a green outline.