Say you’ve gotten a desk of data and also you wished to point out the place there have been matches to a price. You can use the discover operate to do that however what when you wished to have it present extra? Like have it highlighted in a shade? There’s a manner to do that and it is with the Conditional Formatting function in Excel. You enter a price someplace and Excel will seek for it in your desk and spotlight the rows which have that worth. I will present you a manner to do that with as utilizing a case delicate (matching higher case or lowercase) and case in-sensitive match. See the video to learn the way.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Coaching ➜ https://www.exceltraining101.com/p/coaching.html
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/store/dough
⚙️ Instruments: Screencasting ➜ https://techsmith.z6rjha.internet/5Qe53
⚙️ Instruments: Microsoft Workplace ➜ https://microsoft.msafflnk.internet/rKL0G
⚙️ Instruments: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description could include affiliate hyperlinks and we’ll obtain a small fee if a bought is made utilizing the hyperlinks (however at no extra price to you). It’s going to assist the channel and so extra movies like this may be made. Thanks to your assist!
🎁 If you happen to discover these movies helpful and need to assist my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
source