Return to Stark State Home Page
About Stark State
Academics
Class Schedules and Registration Information
Admissions
Campus Information
Donors/Alumni/Foundation
Corporate Services/Contract Training
Continuing Education
Career Services/Employers
Financial Aid/Business Office
Student Services/Student Life
Student Web Access/Student Computing
Stark State College E-Learning
Satellite Centers/Course Sites
Stark State Employment Opportunities
Contact Stark State

STUDENT
COMPUTING

Help Desk Services:
Help Desk Home Page
330-494-6170
Ext. 4357
helpdesk@starkstate.net
Room: B219

Search the Stark State Web Site

Student Computing
Academic Computing Information
   •
Academic Computing Information Home


How to Apply Conditional Formatting - Excel 2007

Click here for a PRINT-FRIENDLY version of this information

Select desired cell range (Figure 1).
Click Conditional Formatting on the menu bar.
When the drop down menu box appears, click New Rule (Figure 2).


Figure 1
 
Figure 2

Under Select a Rule Type select Format only cells that contain (Figure 3).
In the middle text box put desired information (less than, between, greater than equal to) (Figure 3).

In the rightmost box type the value (if less than was chosen and you were looking for all values less than 25.00, this number would be placed in that box).
Click the Format button.
Excel displays the format cells dialog box.
Click on the Font tab and select color box arrow (Figure 4).
Click desired color for the font. Click OK.


Figure 3
 
Figure 4
 
HomeSite MapDirections/MapsFaculty/Staff Remote EmailSSCT Intranet

info@starkstate.edu
© Copyright Stark State College 2008
Privacy statement
Important Browser Information

Stark State College of Technology
6200 Frank Avenue NW
North Canton, Ohio  44720
330-494-6170 | 1-800-79-STARK (1-800-797-8275)