A
ANDNAND
Hi,
Is there a way to increase the number of conditions?
Here are my conditions:
1) Formula is =$R7="WP"
Format: Bold white font + red Pattern
2) Formula is =$R7="PIP"
Format: Bold white font + blue Pattern
3) Formula is =$R7="BD"
Format: Bold white font + black Pattern
This applies to any row from column A to column R
I need to add at least 3-5 more conditions.
Is this done using VBA?, can someone provide the code for it?
Thank you,
Andrew
Is there a way to increase the number of conditions?
Here are my conditions:
1) Formula is =$R7="WP"
Format: Bold white font + red Pattern
2) Formula is =$R7="PIP"
Format: Bold white font + blue Pattern
3) Formula is =$R7="BD"
Format: Bold white font + black Pattern
This applies to any row from column A to column R
I need to add at least 3-5 more conditions.
Is this done using VBA?, can someone provide the code for it?
Thank you,
Andrew