Home » questions » EXCEL and colours?

EXCEL and colours?

7
2006-08-15 07:45:47, Category: Programming & Design
I am preparing a time plan in excel. So what I want to do is to highlight (in one colour) a process that is going to be done in 4 weeks with one colour but with an increasing tone (darkness) in the 4 week period. Anyone with an idea of how I do that?

Answers

  1. essexfriendly

    On 2006-08-15 08:16:20


    Choose the area/row/column you want to highlight choose 'format' and then 'conditional formatting' you can select (for example): If 'cell value' is 'between' (date) and (date) then (colour) If 'cell value' is 'between' (date) and (date) then (next colour) If 'cell value' is 'greater than' (date) then (another colour)

  2. Indigo

    On 2006-08-18 06:44:21


    highlight and click on it

  3. Denise

    On 2006-08-17 17:52:48


    Unfortunately the cell can only be filled with a solid color if you use Format-Cells-Patterns and then choose a color. If you are looking for a gradient that increases tone, I would suggest the following: 1. Drawing a text box around the cells you want to color 2. Right click the border of the Text Box and choose Format Text Box 3. On the colors and lines tab click the Color dropdown list and choose fill effects. 4. For colors I would choose two colors, the first color being the light color (i.e. light turquoise) and the second color being a darker shade of the same color (i.e. turquoise) 5. Under shading styles choose Vertical 6. Click the Variant in the upper left-hand box 7. Click OK to close the fill color menu, click OK to close the Format Text Box menu 8. Type your text in the Text Box Hope this answer works for you!!!

  4. ERIC

    On 2006-08-15 07:53:28


    Just highligth what you want and click fill colour (you can select what colour you want) The fill colour key look like a paint tin.

  5. lohads

    On 2006-08-15 07:54:03


    Go to Format Cells, Patterns and then choose the cell colour you want.

  6. valihuciu

    On 2006-08-15 07:55:24


    It's easy, first select the cell or cells you want to colour, then press right click, choose "Format cells", then choose "Patterns", and from here choose wath colour you want. Succes!

  7. SaD GiRL 83

    On 2006-08-15 07:53:06


    Change the background color of the cell(s). You do it either by using that button that has a little paint can dumping out paint or right click on a cell & go to 'format cells' & change the background color there.