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 réponses

Réponse 1 / 2
diablo13800 Posted messages 3469 Registration date   Status Membre 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
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
diablo13800 Posted messages 3469 Registration date   Status Membre 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
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