View original (French)

Change the cell color based on its text.

fantomex -  
 Picton -
Hello,

I'm sure my problem is quite simple, but I just can't find a solution. In my three-column table (project progress table):

column 1: project title
column 2: progress percentage
column 3: status, the result is displayed according to the progress: "completed" (if % =100); "in progress" (if 1<%<99) and "not started" (if %<1).

I would like my "status" column to be colored green, yellow, and red depending on whether the status is "completed," "in progress," or "not started."

I know it's possible, but I can't figure it out, even when using conditional formatting....

HELP

Configuration: Windows XP / Chrome 40.0.2214.115

2 answers

  1.
    diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872
     
    Hello,

    Use conditional formatting for this

    Select the cell(s)
    Go to Home => Conditional Formatting
    Click on "New Rule..."
    Select "Format cells that contain"
    Instead of "Cell value," select "Specific Text"
    In the value, put "not started."
    Click on Format then Fill
    Select the Red color
    Click OK then OK

    Repeat these steps for each formatting to be done (Yellow, Green...).
    21
    1. fantomex
       
      Thank you, that's what I wanted to do!
      The best thing would have been to replace the colors with small icons ("check" and "cross") but I'll settle for this.
      0
      1. diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872 > fantomex
         
        In this case, you need to use formulas, but this will only be done in one cell.

        In the cell where you want the check, you put this formula
        =IF(progress = '0', "X", IF(AND(progress > 1, progress < 100), "in progress", "Completed"))
        1
    2. Picton
       
      Thank you so much Diablo13800, you just made me smile, be proud of your knowledge and may this whole day be favorable to you, thank you again for sharing your knowledge.
      0