Skip to content

Colouring cell background

Craig AdamsMember for 20 years
Created
7
7
0
Dear Planners,

Can anyone tell me how to automate the colour background of cells based on set criteria in a text cell?

Thanking you,

Craig

7 replies

Oldest first
  1. 0
    Mal Leadbetter ·
    I am not sure you can do this, certianty not in 2002, perhaps in 2007.

    You can use the grapical indicators in 2002. Go to tools, customise fields
  2. 0
    Rafael Davila ·
    If neither Fonts or Text Styles are enough you can create your own conditional formatting using macros; the following link provides you with a sample macro you can adapt to format cell background instead of font color.

    http://articles.techrepublic.com.com/5100-10878_11-1028245.html
  3. 0
    Craig Adams ·
    Thanks Mal & Rafael,

    Your response is appereciated.

    Regards,

    Craig
  4. 0
    Mike Testro ·
    Hi Craig

    In Powerproject you can set up conditional priority spotlight fields - Red - Amber - Green for any time related conditions you wish.

    Best regards

    Mike Testro
  5. 0
    Alexandre Faulx-Briole ·
    Craig,
    I confirm Rafael’s post: it is not possible to conditionally color the cells in MSP, up to MSP 2010; it is only possible to conditionally color the task bars, using a iif formula and a flag field.
    The only way to get what you want is a macro
    Alexandre
  6. 0
    Andrew Lavinsky ·
    You could achieve some of what you’re looking for with a Highlight Filter applied to a view.
  7. 0
    Mike Testro ·
    Hi Andrew

    Welcome to PP.

    Best regards

    Mike Testro

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?