Font styling (bold, italic, color) in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are an office assistant preparing a sales report.

📋 Request: Your manager wants the sales report to be easy to read by highlighting important data with font styles like bold, italic, and color.

📊 Data: You have a table with sales data including Product, Region, and Sales Amount.

🎯 Deliverable: Create a formatted sales report where headers are bold, sales amounts above $500 are bold and green, and regions 'East' are italicized.

Sample Data

Product	Region	Sales Amount
Notebook	East	450
Pen	West	520
Binder	East	610
Marker	South	300
Paper	North	700
Envelope	East	480

1

Step 1: Make the header row bold to highlight column titles.

Select cells A1:C1, then click the Bold button or press Ctrl+B.

Expected Result

Headers 'Product', 'Region', and 'Sales Amount' appear in bold font.

2

Step 2: Italicize the 'Region' cells that have the value 'East' to emphasize this region.

Select cells B2:B7, apply Conditional Formatting with formula =B2="East", set font style to Italic.

Expected Result

Cells in column 'Region' with 'East' are shown in italic font.

3

Step 3: Make sales amounts greater than 500 bold and green to highlight strong sales.

Select cells C2:C7, apply Conditional Formatting with formula =C2>500, set font to Bold and font color to green.

Expected Result

Sales amounts above 500 are bold and green (e.g., 520, 610, 700).

Final Result

Product   | Region | Sales Amount
---------------------------------
Notebook  | East   | 450
Pen       | West   | 520
Binder    | East   | 610
Marker    | South  | 300
Paper     | North  | 700
Envelope  | East   | 480

Note: 'East' regions are italicized, sales >500 are bold green, headers are bold.

✓Headers are clearly visible in bold font.

✓Regions labeled 'East' stand out with italic font style.

✓Sales amounts above $500 are easy to spot with bold green font.

Bonus Challenge

Add a conditional format to highlight sales below $400 in red italic font.

Show Hint

Use Conditional Formatting with formula =C2<400 and set font color to red and font style to italic.