Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

traffic lights

ResolvedVersion 2007

Arienne has attended:
Excel Intermediate course

Traffic lights

How do you do those again?

RE: Traffic lights

Hi Arienne

Thank you for you question

To use the traffic light system of conditional formating

1. Select the data to format
2. On the styles group on the home tab, click conditional formatting and select icon sets
3. Choose the traffic light system

You can also edit the rules by selecting manage rules

Regards

Stephen

Wed 27 May 2009: Automatically marked as resolved.

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.