Hi
I'm a newbie to excel macros; here is my problem
I have to highlight the entire rows for the following four conditions with four different colors.
if column AU contains "b" color=35
if column AU contains "f" color=36
if column D contains "/bin/touch" color=45
if coulmn D contains "/bin/rm" color=22
I have recorded a macro for the first two conditions, using conditional formatting;
then i tried to extend the same macro for all four conditions.
Below is the code for my macro:
When I run the macro it only runs for three conditions the fourth condition is ignored.
I tried to record the same macro for all of the four conditions but i'm unable to; as conditional formatting is allowed only for three conditions.
can i combine conditions 3 and 4 and put them in a if condition. can anyone help me with the if condition
Bookmarks