Search
  • Kalpesh Agrawal

VBA If Else Using For Loop

What if we have lots of data?


The solution is here!


You can solve this problem by using for loop.


The scenario is that you are researching on the time spent by college students on using mobile and its impact on their Eyes.


We are given the following data…



















We are instructed that if the student is using mobile more than 5 hours in a day, has more risk than on their Eye compared to other students, so highlight them in red color.


The code is quite lengthy but you will find an interesting result.


Let’s see…

















You will get the following result.




0 comments

Recent Posts

See All