change background-color depending on cell-content

T

tini

Hello,

There is one cell per row which can have six different
contents. Depending on what there is chosen, I like to
change the background-color from different cells in the
same row. How can I do that? Is it possible without VBA?

Please help me!
 
C

Carlos Pinto

Hi,

Have you tried to use the "Conditional formating"
In the menu select Format->Conditional Formating

PS: I have a portuguese version so I don't know if the
terms in english are those I mention, but they must be
similar.
 

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

Top