200.0K
ANpart 10 of excel for corporate survival:
conditional formatting, but make it useful
this is how you can automatically highlight entire rows based on specific texts in a cell:
1️⃣ select your data range excluding the header
2️⃣ home → conditional formatting → new rule
3️⃣ choose “use a formula to determine which cells to format”
4️⃣ enter your formula, i.e.
• =$B2=“completed” → turns the row green
• =$G2=“Angie” → turns the row yellow
💡 remember to anchor the column with $ so each row checks the right cell
5️⃣ pick your color → ok
6️⃣ repeat for each condition
follow for more excel hacks that actually make corporate life easier ✨
#excel #exceltips #corporatelife #careertips #investmentbanking
@angies_listt
