Ask Experts Questions for FREE Help !
Ask
    RodriguisIUR's Avatar
    RodriguisIUR Posts: 10, Reputation: 1
    New Member
    		  
    #1

    Nov 7, 2009, 03:00 PM
    Format cells with colors in Excel 2007
    Hello,

    I would like to format dynamically a column of cells with various colors in function of the day that is it written in the column before.

    For instance:
    Cells A1:A7 have "Monday;Tuesday;Wednesday;Thrusday;Friday;Saturday ;Sunday"
    Cells B1:B7 will have what I will write in them but I want that these cells have colors in some specific days, like Saturday and Sunday, or if it is holiday like Christmas.

    This will be utilized for a dynamic calendar, changing every year, so I would appreciate any help.

    Thanks.
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
    		  
    #2

    Nov 7, 2009, 03:42 PM

    Select the cells you wish to color. Right-click on the group of cells you've just selected and pick "Format Cells" from the pop-up menu. Select the FILL tab. Select the background color you wish the cells to be.

    If the text isn't very visible after doing this, select the FONT tab. In the middle of the window is an entry box labeled "Color:" Select the text color there.

    This can be done programmatically also.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Nov 7, 2009, 04:04 PM

    Use Conditional Formatting. Its on the Styles section of the Home Ribbon.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Counting multiple cells in Excel [ 4 Answers ]

Hello, I wish to be able to count multiple cells which are not in a row or column adjacent to each other. If know you can use the IF formula to reference any cells you wish without them having to be in a range. How can I count cells specifying a criteria that has to be true which are not in a...

Excel - Count how many cells have a certain color [ 1 Answers ]

Is there a formula to count how many cells within a row have a certain color. For Instance if I have A1 to M1 filled in with text and 8 are colored yellow then I want my result in N1 to say 8. Any way to do this?

Format Cells in Excel 2007 [ 4 Answers ]

Is there a way in Excel to automate adding hyphens in a specific position in a column of numbers (like a mac address list) For example: 0021e96c4183 00-21-e9-6c-41-83 HOWEVER When I use this method Home tab, Cell group, click on Format On Number tab from the Format Cells dialog screen I'd...

Excel - Merge Cells [ 3 Answers ]

Any way to merge a number of cells into one cell, for example the title of many columns in a table?

Multi line cells in excel [ 4 Answers ]

Hey guys, any idea how to have multiple lines in a single cell in excel? I'm trying to make my table look a little neater, but it makes some of my comments overlap into following cells - is there any way to make the rows higher and to have 2 lines of text in a cell? Thanks in advance - Cap

View more questions Search