Excel Conditional Formatting Hack: Highlight Uppercase & Lowercase Words #short

Easy Conditional Formatting Trick: Highlight Uppercase & Lowercase Words in Excel

🔹 Do you want to highlight UPPERCASE and lowercase words differently in Excel? 🔹 Here's a super easy trick using Conditional Formatting!

📌 Step 1: Get Your Data Ready
have a list of words in Column A, some in UPPERCASE and others in lowercase. Now, let's highlight them automatically!

🟢 Step 2: Highlight Uppercase Words
1️⃣ Select your list of words (A1:A10).
2️⃣ Go to Home ... Conditional Formatting ... New Rule (or press Alt + H + L + N).
3️⃣ Choose “Use a formula to determine which cells to format.”
4️⃣ Type this formula: =EXACT(A1, UPPER(A1))
5️⃣ Click Format, pick a Green Fill, and press OK.
Boom! Now, all UPPERCASE words turn green! ✅

Step 3: Highlight Lowercase Words
1️⃣ Repeat Steps 1-3.
2️⃣ Use this formula: =EXACT(A1, LOWER(A1))
3️⃣ Click Format, choose a Red Fill, and press OK.
Now, all lowercase words turn color

#ExcelTips #ExcelTutorial #ExcelFormulas #SpreadsheetSkills #ExcelHacks #LearnExcel #DataAnalysis #ExcelShortcuts #MicrosoftExcel #ExcelForBeginners #AdvancedExcel #ExcelFunctions #ExcelTraining #ExcelMagic #techtutorial #shorts #trending