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...
Watch video How To Format Cells Based On Another Cell Value in MS Excel online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 16 March 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,709 once and liked it 151 people.