Advertisement
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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel problem

  • 08-11-2003 5:47pm
    #1
    CivilServant
    Registered Users, Registered Users 2 Posts: 2,005 ✭✭✭


    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


Comments

  • #2
    Oswald Osbourne
    Closed Accounts Posts: 537 ✭✭✭Oswald Osbourne


    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.


  • #3
    shabbyroad
    Closed Accounts Posts: 1,198 ✭✭✭shabbyroad


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


  • #4
    CivilServant
    Registered Users, Registered Users 2 Posts: 2,005 ✭✭✭CivilServant


    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...


Advertisement