The boss wants you to format a cell in excel based on the content (or appearance) of another cell. 🤔
To solve this you'll need to do three steps:
* Applying conditional formatting to a range of cells
* Create a formula that will apply the format
* Make some minor adjustments to apply the formatting to just the area you want
⌚ *TIMESTAMPS*
0:00 Boss wants you to format a cell based off another cell
0:19 Quick review of conditional formatting
0:24 Quick overview of the data
0:39 Solution Overview
0:54 Conditional formatting using a formula
1:01 Building the formula | An explanation
4:14 BONUS: Going one step further
📢 *FREE RESOURCES*
Mega Excel Keyboard Shortcut List
[ Ссылка ]
Quick Reference Guide
[ Ссылка ]
☕ *BUY ME A COFFEE?*
[ Ссылка ]
How To Format Cells Based On Another Cell Value in MS Excel
Теги
excel formulas and functionsexcel formulasexcel tips and tricksexcel tipsexcel tutorialsExcel Conditional Formatting Based on Another Cellconditional formatting in excel sheets based on another cellsheets conditional formatting based on another cellconditional formatting based on another cellexcel sheets conditional formattingconditional formatting in excel sheetsexcel sheetssheetsspreadsheetconditional formattingconditional formatting excel sheets