Sir how do we find and learn this =cell….. formula in excel. This type of formulas any list are there ? And also the view code section. How to learn this type of codes ? Please guide🙏🏻
Thank you Sir, but how can I make this rule permanent. Because, I perform it but after leaving and closeing Excell program it disappeared.... What sould I do then. I'm waiting answer... Thanks again...
Interesting, nevertheless, is a function that could be automatically implemented by a shortcut and kept by default. Hello Microsoft? Why nobody thought that before, that is so useful and better that the transparent or gray lines.
Hi. Didn't work for me to begin with. So, I made sure to delete any other unnecessary conditional formatting that I had and made sure to follow capitalizations, then it worked.
This one I did but every day I will add more than 10 to 20 lines ,this addition lines also highlight automatically or again i need to update the condition
Useful improvement.
New Innovative Idea
Thank you sir 😊
AMAZING
I really need this
So good thank you
Wow
How is be permanent, can u explain please
Thank you.👌
You are welcome.
can i use this formula in google sheet
Sir how do we find and learn this =cell….. formula in excel. This type of formulas any list are there ? And also the view code section. How to learn this type of codes ? Please guide🙏🏻
Thank you Sir, but how can I make this rule permanent. Because, I perform it but after leaving and closeing Excell program it disappeared....
What sould I do then.
I'm waiting answer...
Thanks again...
@abderrezaklaroui1759, Whenever you will make new Excel sheet document 📄 You have to perform, Auto Highlight setting with every new document.
How?
Interesting, nevertheless, is a function that could be automatically implemented by a shortcut and kept by default. Hello Microsoft? Why nobody thought that before, that is so useful and better that the transparent or gray lines.
How to print the data without the highlight?
I checked the codes again and again, I have enabled dev mode, and applied the code under vba still doesn't work for me...
Hi. Didn't work for me to begin with. So, I made sure to delete any other unnecessary conditional formatting that I had and made sure to follow capitalizations, then it worked.
I have tried everything but it doesnt work with my sheet, what am I doing wrong? Any suggestions?
How can I highlight whole sheet if the rows are updating daily 50 lines each
Press Ctrl + A from your keyboard to select full excel sheet then, perform that method which I teach you in the video
This one I did but every day I will add more than 10 to 20 lines ,this addition lines also highlight automatically or again i need to update the condition