Yes brother, you can assign different colors for different duplicate values in Excel using Conditional Formatting. Here's how to do it step-by-step: Steps to Apply Different Colors for Different Duplicates: 1. **Select the Data Range**: - Highlight the range of cells where you want to check for duplicates. 2. **Open Conditional Formatting**: - Go to the **Home** tab in Excel. - Click on **Conditional Formatting** in the ribbon. 3. **Use a Formula for Conditional Formatting**: - Select **New Rule** from the dropdown. - In the "New Formatting Rule" window, select **"Use a formula to determine which cells to format."** 4. **Enter a Formula for Each Duplicate Set**: - To identify duplicates for specific values, use the following formula: =COUNTIF($A$1:$A$10, A1) > 1 Replace `$A$1:$A$10` with your data range and `A1` as the first cell in your range. - If you want to color only a **specific value** (e.g., "Apple"), use: =AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple") 5. **Set Formatting**: - Click **Format** and choose the **Fill Color** (e.g., Green, Blue, Yellow, etc.). - Click **OK** to confirm the formatting. 6. **Repeat the Steps for Different Duplicate Values**: - For each specific duplicate value (e.g., "Apple," "Orange," "Banana"), create a **new rule** with the same approach. - Change the formula to target the desired value and apply a different fill color. 7. **Apply the Rules**: - Once all rules are created, click **OK** to apply Conditional Formatting. - Excel will now highlight each duplicate set with different colors. Example: Suppose your data range is **A1:A10** and contains the following values: Apple Banana Apple Orange Banana Orange Grapes Apple - **Rule 1**: For "Apple" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple")` → Set **Red** color. - **Rule 2**: For "Banana" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Banana")` → Set **Green** color. - **Rule 3**: For "Orange" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Orange")` → Set **Blue** color. After applying these rules: - Duplicate "Apple" will be highlighted in **Red**. - Duplicate "Banana" will be highlighted in **Green**. - Duplicate "Orange" will be highlighted in **Blue**. --- Important Notes brother: - You need to create a separate **Conditional Formatting Rule** for each value to apply unique colors. - If you have many duplicate values and want an automated approach for different colors, **VBA (macros)** would be required. Let me know if you need help with VBA for automating this process! 😊
SIR SMALL DOUBT....=AVERAGE(D2:F2) ENTER PANNITTEAN ANA NEXT COLUMLA ENAKKU =AVERAGE(D2:F3) VARAUNAM ENNA PANNERTHU SIR.NUMBER 1 FIXED NUBER 2 CHENGE HOW
Stay Connected:
instagram.com/end_less_knowledge
facebook.com/enlessknowledge
whatsapp.com/channel/0029Va5iya9Lo4hbtSeVie3Z
twitter.com/EndlessKnowled1
www.threads.net/@end_less_knowledge
Super Bro 👌
Tally prime couse upload pannuga
Hello Endless Team ,lot of thanks 🎉🎉 pls post the Inventory video
Bro, different types of duplicate values ku different colours kuduka mudiyumaa..
Using conditional formatting...
Yes brother, you can assign different colors for different duplicate values in Excel using Conditional Formatting. Here's how to do it step-by-step:
Steps to Apply Different Colors for Different Duplicates:
1. **Select the Data Range**:
- Highlight the range of cells where you want to check for duplicates.
2. **Open Conditional Formatting**:
- Go to the **Home** tab in Excel.
- Click on **Conditional Formatting** in the ribbon.
3. **Use a Formula for Conditional Formatting**:
- Select **New Rule** from the dropdown.
- In the "New Formatting Rule" window, select **"Use a formula to determine which cells to format."**
4. **Enter a Formula for Each Duplicate Set**:
- To identify duplicates for specific values, use the following formula:
=COUNTIF($A$1:$A$10, A1) > 1
Replace `$A$1:$A$10` with your data range and `A1` as the first cell in your range.
- If you want to color only a **specific value** (e.g., "Apple"), use:
=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple")
5. **Set Formatting**:
- Click **Format** and choose the **Fill Color** (e.g., Green, Blue, Yellow, etc.).
- Click **OK** to confirm the formatting.
6. **Repeat the Steps for Different Duplicate Values**:
- For each specific duplicate value (e.g., "Apple," "Orange," "Banana"), create a **new rule** with the same approach.
- Change the formula to target the desired value and apply a different fill color.
7. **Apply the Rules**:
- Once all rules are created, click **OK** to apply Conditional Formatting.
- Excel will now highlight each duplicate set with different colors.
Example:
Suppose your data range is **A1:A10** and contains the following values:
Apple
Banana
Apple
Orange
Banana
Orange
Grapes
Apple
- **Rule 1**: For "Apple" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Apple")` → Set **Red** color.
- **Rule 2**: For "Banana" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Banana")` → Set **Green** color.
- **Rule 3**: For "Orange" duplicates → Formula: `=AND(COUNTIF($A$1:$A$10, A1) > 1, A1="Orange")` → Set **Blue** color.
After applying these rules:
- Duplicate "Apple" will be highlighted in **Red**.
- Duplicate "Banana" will be highlighted in **Green**.
- Duplicate "Orange" will be highlighted in **Blue**.
---
Important Notes brother:
- You need to create a separate **Conditional Formatting Rule** for each value to apply unique colors.
- If you have many duplicate values and want an automated approach for different colors, **VBA (macros)** would be required.
Let me know if you need help with VBA for automating this process! 😊
Thank you 😊
From jaffna 😊
Thank you, sir. Will you please make one video for the SUMIF function in a set of visible filtered data? (With using subtotal function)
Any online course available?
He already make more excel video, go check excel playlist
Nice sir❤
Bro data analytics course conduct panna mudiuma , yenna ugala vida clear yaralaum soli kuduka mudiyathu please
Select all
Alt O,C,A
Undo also working
Sir Plz Conduct Excel Class
Power BI session podunga bro
பழைய verson இந்த formula use பண்ணலாமா ?
கண்டிப்பாக 😊🎉
Google sheet'la Row and Column Adjustment pannuvathu eppati sir
Default ஆ 😮every time excel open ஆகும் போது இந்த auto fit work ஆக வைக்க முடியுமா? 🤔
Bro period mark eppadi kuduppathu
Anna excel a enakku oru data multiple row la fill series a entry aganum sollunga anna ❤
Ajitheyy 💯
hi bro in my mac i got error, Variable uses an Automation type not supported in Visual Basic...... please give me a solution
Excel using ai tools video podunga
Bro excel la programming language pani vids potunga bro
SIR SMALL DOUBT....=AVERAGE(D2:F2) ENTER PANNITTEAN ANA NEXT COLUMLA ENAKKU =AVERAGE(D2:F3) VARAUNAM ENNA PANNERTHU SIR.NUMBER 1 FIXED NUBER 2 CHENGE HOW
❤
Hi anna
hi sir
wow🦢🥀🌴🌴