If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
Great. I have a worksheet and at the end I have a drop down list with: "In Stock and Out of Stock:. I want to highlight the row when I select "Out of Stock".. Will I be able to do that?
Hi, You can do it using Conditional Formatting with Formulas. • Example: the dataset range is A1: F100. • Column#E contains the drop-down list. 1. Select range A2:F100. 2. Home tab --> Conditional Formatting drop-down --> New Rules A dialog box will open. 3. In the dialog box --> in the top half --> select the last option: "Use a formula to determine which cells to format". 4. In the bottom half . . type: = $E2 = "Out of Stock" 5. Click on the Format button to apply formatting. 6. Click O.K. . . and O.K. Hope, this helped.
A very complete tutorial. Thank you Sir!!
Thank you! I have been wanting to discover how to highlight with macros for a while. Very clear. Well done!
Thank you very much!!!!
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
Thank you Trump for this nice video 📹 👍
👍👍👍. One more, How to count automatically selected rows? Say, five selected rows and in one cell I can see the total number of rows count. Thanks.
Awesome thank u so much
Great. I have a worksheet and at the end I have a drop down list with: "In Stock and Out of Stock:. I want to highlight the row when I select "Out of Stock".. Will I be able to do that?
Hi,
You can do it using Conditional Formatting with Formulas.
• Example: the dataset range is A1: F100.
• Column#E contains the drop-down list.
1. Select range A2:F100.
2. Home tab --> Conditional Formatting drop-down --> New Rules
A dialog box will open.
3. In the dialog box --> in the top half --> select the last option: "Use a formula to determine which cells to format".
4. In the bottom half . . type:
= $E2 = "Out of Stock"
5. Click on the Format button to apply formatting.
6. Click O.K. . . and O.K.
Hope, this helped.
How amazing is the way your are explaining.
A quite methodological approach, Thank you for everything.
In conditional Formatting,why you give only single cell reference A1 and how this apply in entire worksheet by giving single cell reference??
Sir
Could you please tell me how Vba can be applied in Internal audit. Thanks
Very Nice video Bro.. What is the use of DoEvent in VBA, please make a video on same.. Thanks
Very well explained. Thank you.
SIR YOUR FIRST PLAYLIST FOR EXEL IS ENOUGH TO MASTER IN EXEL OR I WILL HAVE TO WATCH ALL THE PLAYLISTS
You are best