Posted by: gracelydia51 | June 30, 2011

Applying Conditional Formatting in Excel

When a formatting applied to a particular cell or cells and it activates only when a condition is fulfilled then it is known as conditional formatting. For example a condition can be applied that if value in a cell becomes more than 200, all the values in that particular cell will become bold. This means that while doing conditional formatting, a condition or a criteria needs to be specified for formatting. If you also want to apply conditional formatting to your data in Excel sheet, follow these simple steps:

  • Select a particular cell to which you want to apply conditional formatting.
  • From the Format menu, select Conditional Formatting command. Conditional formatting dialog box will be appeared.
  • Now specify the condition.
  • To apply formatting, click Format button. Format Cells dialog box will appear on your computer screen. Here you will specify the format you want.
  • If you want to specify another condition, click Add button. You can specify maximum three conditions.
  • Now click OK.

If you don’t want to apply conditional formatting to cells and want to delete it, you can do so by following these steps:

  • Select a particular cell from which you want to remove conditional formatting.
  • From the Format menu, select Conditional Formatting command and you will see Conditional Formatting dialog box.
  • To remove a condition, click Delete. You will be asked which of the three conditions you want to delete.
  • After selecting condition, click OK button.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: