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

08-11-2003 05:47PM

#1

CivilServant

Registered Users, Registered Users 2 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

#2 08-11-2003 06: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
#3 08-11-2003 06: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
#4 08-11-2003 06:25PM

CivilServant

Registered Users, Registered Users 2 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