CONDITIONAL FORMATTING TO VBA. Row format based on cell value.

A

ANDNAND

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
Conditional formatting limit to 3 Excel 2003 5
Conditional Formatting - Color row based on one cell value 1
A Huge Conditional Format Challenge.... 2
VBA Conditional Formatting 0
conditional formatting, filtering then copying to another sheet 0
Apply cell formatting using VBA 2
Conditional formatting puzzle 2

Top