Changing color of a row depending on coloum values?

Changing color of a row depending on coloum values?

Post by Lars Rasmu » Fri, 07 Jan 2005 17:54:36


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
 
 
 

Changing color of a row depending on coloum values?

Post by Bob Philli » Fri, 07 Jan 2005 18:31:46

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.yqcomputer.com/

--

HTH

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

 
 
 

Changing color of a row depending on coloum values?

Post by Lars Rasmu » Fri, 07 Jan 2005 19:16:12


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