Highlight the entire row

[ramky79]

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:

Please Login or Register  to view this content.

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

[venkat1926]

why not try this macro

Please Login or Register  to view this content.

I HAVE A DOUBT. what happens if col D has that text e.g. "bin/touch" and column AU has "d" or "f". the above macro will give result of latest statement only