iferror function conditional formatting

[jbrown021286]

TECH HOURS WORKSHEET 3.0.xlsx
	A	B	C	D	E	F	G	H	I
1	Date	Total Tech 3/4's Available	Total Tech 3/4's Flagged	Proficiency %		Total Tech 1/2's Available	Total Tech 1/2's flagged	Proficiency %
2	1-Feb	6	29	60%	-3.17	14	72.2	64%	-2.84
3	2-Feb	7	76.1	136%	2.87	15	68.1	57%	-3.46
4	3-Feb	7	63.75	114%	1.11	15	68.9	57%	-3.41
5	5-Feb	4	32.9	103%	0.23	10	50.9	64%	-2.91
6	6-Feb	6	75.2	157%	4.53	13	48	46%	-4.31
7	7-Feb	6	39.4	82%	-1.43	13	59	57%	-3.46
8	8-Feb	6	46.7	97%	-0.22	14	68.1	61%	-3.14
9	9-Feb	6	68.4	143%	3.40	14	66.9	60%	-3.22
10	10-Feb	6	88.1	184%	6.68	14	85.8	77%	-1.87
11	12-Feb	6	38.3	80%	-1.62	13	59	57%	-3.46
12	13-Feb	5	41.5	104%	0.30	11	54.15	62%	-3.08
13	14-Feb	6	46.9	98%	-0.18	12	69.2	72%	-2.23
14	15-Feb	6	46.15	96%	-0.31	13	63.9	61%	-3.08
15	16-Feb	8	80.9	126%	2.11	14	77.2	69%	-2.49
16	17-Feb	6	55.6	116%	1.27	15	74.5	62%	-3.03
17	19-Feb	6	67.35	140%	3.23	12	57	59%	-3.25
18	20-Feb	6	49.2	103%	0.20	11	55.5	63%	-2.95
19
20
21
22
23
24
25
26
27
28
Delta Table

Cell Formulas
Range	Formula
A1:A28	A1	=IF('[Daily Service Manager Report 2024.xlsx]Feb. 24 '!A1="","",'[Daily Service Manager Report 2024.xlsx]Feb. 24 '!A1)
B1:D28	B1	='[Daily Service Manager Report 2024.xlsx]Feb. 24 '!B1
F1:H28	F1	='[Daily Service Manager Report 2024.xlsx]Feb. 24 '!E1
E2:E18,I2:I18	E2	=(C2/B2)-8
E19:E28	E19	=IFERROR(C19/B19-8,"")
I19:I28	I19	=IFERROR(F19/B19-8,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:E28,I2:I28	Cell Value	=0	text	NO
E2:E28	Cell Value	<-1.5	text	NO
E2:E28	Cell Value	<0	text	NO
E2:E28	Cell Value	>1.5	text	NO
E2:E28	Cell Value	>0	text	NO
I2:I28	Cell Value	<-1.5	text	NO
I2:I28	Cell Value	<0	text	NO
I2:I28	Cell Value	>1.5	text	NO
I2:I28	Cell Value	>0	text	NO

i have a conditional formatting range in columns E and I. i have and iferror formula to remove errors but i need the cells to be white if the cell is showing empty

 

[Joe4]

Change the condition on your current white rule.
Instead of using "Cell Value", use the formula option, and enter the formula:

=OR(E2=0,E2="")

and set the "Stop If True" value to TRUE so it does not always evaluate all the other rules under that for those cells.