If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel problem

CivilServant · 2003-11-08 17:47:07

Indexing my film list by genre, name, etc.... Since there a quite a few films, i want to colour code them by genre, is there a way to do that in excel? Thanks

Options

08-11-2003 6:47pm

#1

CivilServant

Registered Users Posts: 2,005 ✭✭✭

Join Date: June 2002

Posts: 1860

Indexing my film list by genre, name, etc.... Since there a quite a few films, i want to colour code them by genre, is there a way to do that in excel? Thanks

0

Comments

Options
#2 08-11-2003 7:03pm
Oswald Osbourne

Closed Accounts Posts: 537 ✭✭✭

Join Date: September 2003

Posts: 497

What I'd do is firstly do a sort by the genre column and then highlight a block of cells corresponding to each genre. That way you only have to choose and apply a colour once for each genre. You can choose to colour either the text or the cell itself from the toolbar menu at the top.

0
Options
#3 08-11-2003 7:20pm
shabbyroad

Closed Accounts Posts: 1,198 ✭✭✭

Join Date: October 2001

Posts: 1014

you can use "conditional formatting" - that will allow you to format the text in one cell depending upon the value in another cell

0
Options
#4 08-11-2003 7:25pm
CivilServant

Registered Users Posts: 2,005 ✭✭✭

Join Date: June 2002

Posts: 1860

That's a good idea shabbyroad, but as i keep adding new films, i don't want to redo the colours over and over again. Was looking for something that would include an excel function. Something like "comedy"=red, horror="blue", etc...

0