🎨 Excel-15

✨ Project Description

Excel-15 is your practical guide to mastering conditional formatting in Microsoft Excel. Learn how to visually analyze your data using color scales, data bars, icon sets, and more—plus tips for finding duplicates, blank cells, and customizing your workbooks.

📚 Goal: Help you use Excel's formatting features more efficiently—ideal for both beginners & advanced users!

---

📒 Table of Contents

• Conditional Formatting
• Clear Rules
• Top/Bottom Rules
• Conditional Formatting with Formulas
• Color Scales / Heat Map
• Highlight Blank Cells
• Manage Rules
• Data Bars
• Find Duplicates
• Find Duplicate Rows
• Screenshots
• Requirements
• Author

---

🟨 Conditional Formatting

Use conditional formatting to automatically highlight cells based on their content.
Apply a rule or use a formula to determine which cells to format.

Example: Highlight cells greater than a value:

1. Select the range A1:A10.
2. Go to Home → Styles → Conditional Formatting.
3. Click Highlight Cells Rules > Greater Than.

4. Enter value (e.g. 50) and select a formatting style.

5. Click OK

6. Change the value of cell A1 to 70.

Result: Excel changes the format of cell A1 automatically.

---

🧹 Clear Rules

To clear a conditional formatting rule:

1. Select the range A1:A10.
2. Go to Home → Styles → Conditional Formatting.
3. Click Clear Rules > Clear Rules from Selected Cells.

---

🔼 Top/Bottom Rules

Highlight cells above average:

1. Select the range A1:A10.
2. Go to Home → Styles → Conditional Formatting.
3. Click Top/Bottom Rules > Above Average.
4. Select a formatting style.

5. Click OK.

Result: Excel calculates the average and formats the cells above it.

---

🧮 Conditional Formatting with Formulas

Apply formatting using custom formulas:

1. Select the range.
2. Go to Home → Styles → Conditional Formatting.
3. Click New Rule.

4. Select Use a formula to determine which cells to format.
5. Enter a formula (e.g. =ISODD(A1)).
6. Select a formatting style and click OK.

Result: Highlights all odd numbers.

📝 Tip: Write the formula for the upper-left cell in your selected range.
Formulas must evaluate to TRUE or FALSE.

---

🌡️ Color Scales / Heat Map

Create a heat map where values are represented as colors:

1. Select the range B3:M11.
2. Go to Home → Styles → Conditional Formatting.
3. Click Color Scales and choose a subtype.

Result: A heat map with numbers.

4. Select the range B3:M11.
5. Right click, and click Format Cells (or press CTRL + 1).
6. Select Custom category.
7. Type the number format code: ;;;

8. Click OK.

Result: A heat map in Excel.

---

🟦 Highlight Blank Cells

Find and format blank cells:

1. Select the range of cells.
2. Go to Home → Styles → Conditional Formatting.
3. Click Highlight Cells Rules > More Rules.
4. Select Blanks from the drop-down, choose a style, and click OK.

Result:

---

🗂️ Manage Rules

View, create, edit, or delete all your formatting rules:

1. Select cell A1.
2. Go to Home → Styles → Conditional Formatting.
3. Click Manage Rules.

The Conditional Formatting Rules Manager appears:

📝 Tip: Use New Rule, Edit Rule, and Delete Rule to manage your rules.

---

📊 Data Bars

Visualize values using data bars—longer bar = higher value:

1. Select a range.
2. Go to Home → Styles → Conditional Formatting.
3. Click Data Bars and choose a subtype.

Result:

📝 Tip: Customize your data bars (Show Bar Only, Minimum/Maximum, Appearance, Negative/Axis, Direction, etc).

You can also add color scales, icon sets, etc.

---

🟩 Find Duplicates

Highlight duplicate values:

1. Select the range.
2. Go to Home → Styles → Conditional Formatting.
3. Click Highlight Cells Rules > Duplicate Values.
4. Choose a formatting style and click OK.

Result: Excel highlights the duplicate names.

---

🟪 Find Duplicate Rows

Find and highlight duplicate rows using a formula (COUNTIFS):

1. Select the range A2:C7.
2. Go to Home → Styles → Conditional Formatting.
3. Click New Rule.
4. Select Use a formula to determine which cells to format.
5. Enter the formula (see below).
6. Choose a formatting style and click OK.

Result: Excel highlights the duplicate rows.

📝 Tip: Lock the reference to each column using $ (e.g. $A1, $B1, $C1).
This ensures each formula is applied correctly to each cell.

---

📷 Screenshots

All screenshots are available in the /Screenshots folder.

---

ℹ️ Requirements

• Microsoft Excel (recommended: 2021/365)
• Windows OS

---

👨‍💻 Author

Project and documentation by Kuba27x
Repository: Kuba27x/Excel-15

---