How To Format Cells Based On Another Cell Value in MS Excel
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
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ BUY ME A COFFEE?
https://www.buymeacoffee.com/professo...
Смотрите видео How To Format Cells Based On Another Cell Value in MS Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 16 Март 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 10,709 раз и оно понравилось 151 людям.