Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2013, 07:55 AM
tatihulot tatihulot is offline Cell Background Color:  Base it on Content of Cell? Windows 8 Cell Background Color:  Base it on Content of Cell? Office 2010 (Version 14.0)
Advanced Beginner
Cell Background Color:  Base it on Content of Cell?
 
Join Date: Apr 2010
Posts: 34
tatihulot is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-14-2013, 08:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Cell Background Color:  Base it on Content of Cell? Windows 7 64bit Cell Background Color:  Base it on Content of Cell? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

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
Reply With Quote
  #3  
Old 08-14-2013, 08:24 AM
tatihulot tatihulot is offline Cell Background Color:  Base it on Content of Cell? Windows 8 Cell Background Color:  Base it on Content of Cell? Office 2010 (Version 14.0)
Advanced Beginner
Cell Background Color:  Base it on Content of Cell?
 
Join Date: Apr 2010
Posts: 34
tatihulot is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 08-14-2013, 09:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Cell Background Color:  Base it on Content of Cell? Windows 7 64bit Cell Background Color:  Base it on Content of Cell? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,435
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

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
Reply With Quote
  #5  
Old 08-14-2013, 03:24 PM
tatihulot tatihulot is offline Cell Background Color:  Base it on Content of Cell? Windows 8 Cell Background Color:  Base it on Content of Cell? Office 2010 (Version 14.0)
Advanced Beginner
Cell Background Color:  Base it on Content of Cell?
 
Join Date: Apr 2010
Posts: 34
tatihulot is on a distinguished road
Default

I got it! All the colors. It took some minor tweaking, but it worked.

Thank you for your help.

Jd
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Background Color:  Base it on Content of Cell? 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 Background Color:  Base it on Content of Cell? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft