#1
|
|||
|
|||
Cell Background Color: Base it on Content of Cell?
Hello, I am using Office Home and Student 2010 and have an Excel 2010 question. I’ve been using Filemaker Pro 12 to manage my movie collection, and have exported the database records to a .xlsx file. It appears to have exported fully and properly. Now, I’m working with Excel 2010 and Access 2013, which I bought last week. Anyway, here’s my question: One of my Excel columns is “Color.” (My movie collection is color-coded based on genre.) I’d like the background color of the cells in this column to reflect the information in each cell. For example, if the word RED is in a cell, I want that cell to be red. If the word BLUE is in a cell, I want the color to be blue. Et cetera. Do I need to use Conditional Formatting for this, in Excel 2010, or does this require something else? How do I go about learning how to do this? Thank you for any assistance you care to give. J. Danniel |
#2
|
||||
|
||||
This should work fine with CF. However if you have many colours it will take some time to set up ( and might slow your sheet down). In this last case there should be some VBA code on the Net
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I guess the issue now is how many is "many?"
There will be seven colors. Is there a web site or tutorial site you can recommend in particular, to explain how to do this? Thank you! Jd |
#4
|
||||
|
||||
Seven does not seem to be undo-able
Select your range - Home Ribbon- Conditional formatting - New rule - Use a formula - Enter =$A1="red" and format as needed Do the same for the others always using $A1 ( if col A of course, otherwise, adapt as needed) You could probably find more explanation on YouTube or similar sites
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
I got it! All the colors. It took some minor tweaking, but it worked.
Thank you for your help. Jd |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to add background CELL image | rosede | Word Tables | 2 | 11-15-2012 07:08 AM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |
Cell content splits | Mahen | Excel | 2 | 05-15-2011 01:53 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
How can I make a cell color RED under the Today's date cell? | Learner7 | Excel | 2 | 07-08-2010 12:52 AM |