Hi

This question has been asked before in some variations, but i did not find
any that meat my requirements.

I would like to change a row colour (e.g. By:Jy) if cell By contains a
specific value (letters, numbers, words).
I would like to be able to setup multiple rules for this coloring.

Conditional Formatting is too limited here.

I'm sure that you experts have a code snip that i can use ;-)

br Lars

I assume that you mean CF is too limited as it is restricted to 3
conditions.

For more than 3 conditions, you need VBA event code. If you want to avoid
building the code, there is a free add-in to do it for you at
http://www.xldynamic.com/source/xld.....Download.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lars Rasmussen" wrote in message
...
Hi

This question has been asked before in some variations, but i did not find
any that meat my requirements.

I would like to change a row colour (e.g. By:Jy) if cell By contains a
specific value (letters, numbers, words).
I would like to be able to setup multiple rules for this coloring.

Conditional Formatting is too limited here.

I'm sure that you experts have a code snip that i can use ;-)

br Lars

"Bob Phillips" wrote in message
...
I assume that you mean CF is too limited as it is restricted to 3
conditions.

For more than 3 conditions, you need VBA event code. If you want to avoid
building the code, there is a free add-in to do it for you at
http://www.xldynamic.com/source/xld.....Download.html

Hi

Thanks for the reply.
But then this has to be intalled on every PC that should view/print/edit
this spreadsheet?

I was probably looking for some few lines of code that i could paste into
the VB editor.

br Lars