Thread: Vba loop and if arguments

Please i need help with this vba question !

write a VBA subroutine that performs the following:
 Changes the font color of
the salaries to red color for
any faculty member whose
rank is either senior lecturer
or senior professor and has
less than 9 years of
experience.
 Changes the font color of the
employee to green color for
any faculty member whose primary schedule is afternoon and secondary schedule is online.


Cheers

What code have you got so far? Where are you stuck?

Why do this with VBA? Conditional formatting would suffice and would be preferable.

This sounds like a homework assignment. You will not find anybody on this site who will help you cheat and write it for you. But if you have a question about a particular aspect or a problem with your code, then you will find plenty of help here.

Post your code.

cheers,