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

ANDNAND

Guest

Posts: n/a

18th Apr 2008

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

« Deleting excel rows based on multiple criteria | Moving the last character within the cell so it will be the first »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting based on format in a different cell	Mary Katherine	Microsoft Excel Worksheet Functions	1	30th Dec 2009 09:55 PM
Conditional formatting Based on cell A text with conditions in Cell B	Raicomm	Microsoft Excel Misc	0	21st Jan 2008 04:46 PM
conditional Formatting based on cell formatting	Totom	Microsoft Excel Worksheet Functions	1	20th Jan 2007 02:02 PM
Conditional Formatting 4+ conditions, format rows based on cell	nockam	Microsoft Excel Programming	10	12th Jul 2006 11:12 PM
Conditional cell background formatting, based on cell content	nosivad	Microsoft Excel Misc	5	11th Feb 2006 11:12 PM