how to Apply Condition Formatting in Particular Cells At a time ??? (Rules : " <1 " Highlight Cell color to RED After Zero .)

[krunal123]

 

[etaf]

Select the range F6 to F?? to how many rows you want
Then a conditional format rule

=AND( F6<>"",F6=0) - see example below

It will highlight if any other cell also = zero
So you could just use the Total Available as part of the AND

=AND( E6="Total Available",F6=0) - see example below

Book8
	B	C	D	E	F
5					Quantity
6
7
8
9
10
11
12
13				total available	0
14
15
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
F13	F13	=SUM(F6:F12)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F6:F23	Expression	=AND(F6<>"",F6=0)	text	NO

Using total available

Book8
	B	C	D	E	F
5					Quantity
6
7
8
9
10
11
12
13				total available	0
14
15
16
17
18
19
Sheet1

Cell Formulas
Range	Formula
F8	F8	=IF(SUM(D8:E8)=0,"",SUM(D8:E8))
F13	F13	=SUM(F6:F12)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F6:F23	Expression	=AND(E6="total available",F6=0)	text	NO