Computer Online Tips
System Security TipsSet Home PageAdd to
Favorites|
|
||||
|
System Security Tips |
Set Home Page |
Add to
Favorites |
||
|
|
Categories
System
Performance TipsComputer
TroubleshootingComputer
Security TipsMS
Office TipsInternet
TroubleshootingSystem
Backup TipsWindows
TricksWindow Registry
Tips
How to apply Conditional Formatting in MS Excel?
A formatting that is applied to a cell or multiple cells and activated only if condition is met is called conditional formatting. For example, if a condition is applied in a selection that when any value in the selection is greater than 400, the value in the respective cell will be bold, under line or show with different color. For example, the conditional formatting is applied to the cells C4 to C12. When values in these cells are changed, Excel automatically updated the format of the cells.
In conditional formatting, you have to specify a condition or criteria for formatting. The criteria are specified in the conditional formatting dialog box.
Perform the following steps to apply the conditional formatting:
Select the cells, you want to apply the conditional formatting.
Choose conditional formatting command from the Format menu then conditional formatting dialog box will appear.
Here under Condition section, specify the condition.
Click Format button to apply formatting. Format cells dialog box will appear. Specify the format you want.
Click Add button to specify another condition. You can specify up to three different conditions.
At the end, click on OK button to save these all conditions.
How
to apply Conditional Formatting in MS. Excel?
A
formatting that is applied to a cell or multiple cells and activated
only if condition is met is called conditional formatting.
How
to present text in the form of columns?
The text
of word document can be arranged into multiple columns. The number of
columns that can be created in document depends upon the size of paper.
How to
insert a sound or music on a PowerPoint Slide?
MS- Power Point helps
to create and organize presentations very easily and quickly and
presentation is a systematic approach through which ideas are delivered
to others in a will-mannered way.
How to manage the Paragraph and line Spacing? The white spacing before and after the paragraph are called paragraph spacing. Similarly, the white space between adjacent lines is called line spacing.
How to use Shrinking and Wrapping features in Excel? Excel also has feature to fit data in cells by shrinking the data. The data of cell or range of cells is fitted within its column width by reducing its font size.
Subscribe
To Our Weekly Newsletters
Bookmark this page
Email
this to your friend 
|
Home | Disclaimer | Link
to Us | Contact
Us Copyright 2007 www.ComputerOnlineTips.com All rights reserved. |