I have set 3 conditional formatting rules where the row from column A to K
will change depending on the value on column L.

Selection is equal to A3:K100, conditions are similar to:
- "Formula is" =$K3="PIP"

Then for formatting I chose WHITE BOLD FONT & BLUE SOLID PATTERN, for example.

Conditional formatting only allows 3 conditions. If this can be replicated
using VBA, then you can set "n" conditions, correct?

Please help, thank you

Andrew