Highlight cell when a percentage amount has been met.

[mkrass]

How can I dynamically highlight a cell that shows when I have reached a pre-determined percentage amount from a defined labor budget?
Budgeted hours - 80
Threshold - 80%

Day 1 - 8 hours
Day 2 - 8 hours
Day 3 - 8 hours
Day 4 - 8 hours
Day 5 - 8 hours
Day 6 - 8 hours
Day 7 - 8 hours
Day 8 - 8 hours
Day 9 - 8 hours
Day 10 - 8 hours
I would like to highlight the cells for Days 8, 9,10, etc. as they are greater than or equal to 80% of budgeted hours.

 

[Peter_SSs]

Welcome to thee MrExcel board!

It depends how your data is actually presented in your worksheet.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this Conditional Formatting heads you in the right direction.

24 03 13.xlsm
	A	B
1
2	Budgeted hours	80
3	Threshold	80%
4
5	Day	Hours
6	1	8
7	2	8
8	3	8
9	4	8
10	5	8
11	6	8
12	7	8
13	8	8
14	9	8
15	10	8
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:B15	Expression	=SUM(B$6:B6)>=B$3*B$2	text	NO

 

[mkrass]

 

[mkrass]

Welcome to thee MrExcel board!

It depends how your data is actually presented in your worksheet.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this Conditional Formatting heads you in the right direction.

24 03 13.xlsm
	A	B
1
2	Budgeted hours	80
3	Threshold	80%
4
5	Day	Hours
6	1	8
7	2	8
8	3	8
9	4	8
10	5	8
11	6	8
12	7	8
13	8	8
14	9	8
15	10	8
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:B15	Expression	=SUM(B$6:B6)>=B$3*B$2	text	NO

Thank you. I will download the add-on and I will try the test area. Also, thank you for the suggestion, I will try that as well and I'll let you know how it went.

 

[Peter_SSs]

Given the image layout (XL2BB still better because we can copy from it to test whereas a picture we have to manually type. ) the adjustment to the Conditional Formatting would be

24 03 13.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1					1/01/2024	2/01/2024	3/01/2024	4/01/2024	5/01/2024	6/01/2024	7/01/2024	8/01/2024	9/01/2024	10/01/2024	11/01/2024	12/01/2024
2	Budgeted hours				8	8	8	8	8	8	8	8	8	8	8	8
3	100
4
5	0.80
CF (2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:P2	Expression	=SUM($E2:E2)>=$A3*$A5	text	NO

 

[mkrass]

Welcome to thee MrExcel board!

It depends how your data is actually presented in your worksheet.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this Conditional Formatting heads you in the right direction.

24 03 13.xlsm
	A	B
1
2	Budgeted hours	80
3	Threshold	80%
4
5	Day	Hours
6	1	8
7	2	8
8	3	8
9	4	8
10	5	8
11	6	8
12	7	8
13	8	8
14	9	8
15	10	8
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:B15	Expression	=SUM(B$6:B6)>=B$3*B$2	text	NO

Peter,
Thank you again. I am trying to learn the absolute and relative reference syntax. If the data is horizontal, .i.e., all in row 3. Is the syntax SUM(A$3:A3)? if the data is in cells F3:AJ3? (I know this is a basic question).

 

[Peter_SSs]

If the data is horizontal,

I have given the syntax for that in post #5. The $ signs need to lock the columns.