Conditional formatting to visually gauge progress towards target value

[stusam]

Hi.

I have a simple sheet that shows the individual duration, in minutes, of a series of activities in column H, and their combined total duration, in hours and minutes, in column I. The heading of column I also displays the "target" duration. In this example, the target is 5:00 hours.

Is it possible to use conditional formatting to gradually "fill" the total duration cell with a colour (green) as activities and their durations are added, and the target duration is approached, with the colour finally filling the cell when the target is met?

A couple of additional, but not essential, requirements:

1. Ideally, the green fill colour would be a gradient from green to transparent, that creeps up as the total duration moves closer to the target.
2. The fill colour switches to red if the target is exceeded.

! NEW Module Map Template V2.3.xlsx
	G	H	I
1	Activity Number	Activity Duration (Minutes)	Total Duration (Hours:Minutes) (Target =5:00)
2	1	90	4:50
3	2	10
4	3	20
5	4	10
6	5	10
7	6	30
8	7	120
9	8
10	9
11	10
Sheet2

Cell Formulas
Range	Formula
I2	I2	=SUM(H2:H11)/60/24

Thank you for any guidance provided.

 

[DanteAmor]

It could be in an auxiliary column, for example in column I insert a column, in cell I1 the target and in cells I2 to I11 a formula to calculate the increment.
You must create 2 rules, one rule with 2-scale format style for the green ones; and another rule for red:

Libro1
	A						G	H	I	J
1							Activity Number	Activity Duration (Minutes)	5	Total Duration (Hours:Minutes) (Target =5:00)
2							1	90	1.5	06:10
3							2	10	1.7
4							3	20	2.0
5							4	60	3.0
6							5	40	3.7
7							6	30	4.2
8							7	120	6.2
9							8
10							9
11							10
Hoja2

Cell Formulas
Range	Formula
I2:I11	I2	=IF(H2<>"",SUM($H$2:$H2)/60,"")
J2	J2	=SUM(H2:H11)/60/24

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:I11	Expression	=AND($I2<>"",$I2>$I$1)	text	NO
I2:I11	Other Type	Color scale		NO

Review how the data should be in the 2-scale format style: