How to use conditional formatting in excel?

Question

How can I use condtional formatting in excel to highlight people in the engineering department. How can i create or formula or condition for that?

Answer 1

Open an existing Microsoft Excel document in which to create these conditional formats. Double click on the "My computer" option on the main operating system desktop. Choose the location of the Excel file and double click on the file icon to open the document.



Ascertain which cells or worksheet the conditional formatting will apply to. Prior to opening the conditional formatting manager, choose particular cells, the entire worksheet or workbook to apply the conditional format.



Choose the "Conditional Formatting" button from the home menu ribbon. Then select the "Manage Rules" option from the conditional formatting menu.



Click on the "New Rule" button from the conditional formatting rules manager dialogue box.



Select the type of rule to create. There are six types of rules that a user can create, in this case the "Format All Cells Based on Their Values" type will be utilized.



Determine the scheme and value basis for the condition format rule. For instance, a user can make the color of each cell vary based on the number in the cell. The highest number gets a certain color while the lowest gets another color. All the numbers in between will be assigned a variation on color scheme based on the value relative to the highest and lowest number in the spreadsheet.



Apply the format style to the conditional format. There are four options to choose from. In this case, a "2-Color Scale" was used.



Save the rule and the spreadsheet once the conditional formatting rule is complete.

Answer 2

1) Select the column you want to format (or select all the cells)

2) Click on "Conditional Formatting" button and choose "New Rule" from the list

3) Under "Select a rule type" choose "Format only cells that contain"

4) and change the "Edit the Rule Description" from "Cell Value" to "Specific Text"

5) Type "Engineering" in the blank box to the right of the "containing" box

6) Then click on the Format button and select the formatting that you want to apply to the Engineering people.

7) Click "OK"



Hope this helps

Answer 3

Here is a link to a good short demo on conditional formatting: http://office.microsoft.com/en-us/excel/HA101655491033.aspx?pid=CH100740791033