answersLogoWhite

0

Yes. There is a facility in Excel called Conditional Formatting that will allow you to do that.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What format is used to display non-currency numbers?

There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.


What is a predefined set of text formats that can be applied from the Ribbon?

Quick Style


What file format are drawings saved in?

There are hundreds of possible formats for graphics. Some common formats are JPG, GIF, TIF, and many more.


How could you find cells that have a highlight cell rule applied?

Use Go to Special and choose conditional formats


What is AutoFormat on Microsoft Excel?

Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.Autoformat allows you to apply pre-defined formats to your data, normally in table structures. This includes settings for fonts, colours, patterns, headings, raw data and calculated data. You can choose from a wide range of these formats and have all the settings applied at once, saving you lots of time.


If A formula references a range of cells that contain a variety of formats the format from the cell in the lower right corner of the range will be applied?

its False


What kind of video formats are available for Windows Media Player?

Wndows Media Player is capable of playing a wide variety of different video formats. Examples include .wmv and .avi. A comprehensive listing of possible formats is available at the official Microsoft website.


What is a specific way in which Excel displays numbers in a cell?

It can be called the format of the cell. Specific formats include percentage, general, currency and others.


Is there a specific format for writing a business plan?

No, there is no specific format. However, if you want help there are templates and formats available on the internet as well as other useful hints and tips.


Are bullets and numbering applied with a toggle button?

Yes, bullet and number formats are applied with a "toggle button," meaning a button turns the formatting function on and off. The user doesn't need to set tabs or indents, or type the bullet characters or numbers.


In Excel can you create your own custom formats?

Yes. It is possible to create custom formats for things like dates, currencies and numbers etc. Type in some values you want to format first. Then go to the Format menu, click Cells, and you will be given a menu with various formats, the last of which is Custom. Often it is best to pick one of the existing formats first and then customise after that by going in to format again.


Where is it possible to view recordings of depositions?

It is possible to view recordings of depositions at a court of law after it has been processed through a video editing software. The file can be used in many formats.