Conditional formatting formula/steps to format based on criteria

[Amos N]

MinStock ROL On Hand
0.0 300 2298.48
0.0 300 2318.48
49.9 50 46.08
49.9 50 47.67

assist with formula for conditional formatting or Formula to change colour on on Hand column after meeting 3 conditions below

RED if on hand < Minstock

Yellow if min<on hand<=ROL

Green if ROL<on hand

 

[etaf]

three rules

Not sure on the Yellow , as the other 2 rules in your example RED and GREEN are met

RED
=$C2<$A2

GREEN
=$B2<$C2

can you explain YELLOW again
Min is < ONHAND
OR
ONHAND <= ROL
or we can use an AND
AND( Min < ONHAND , ONHAND <= ROL )

But as i say in your example all 4 rows meet either Green or RED

Book5
	A	B	C	D	E	F	G
1	MinStock	ROL	On Hand
2	0	300	2298.48				RED if on hand < Minstock
3	0	300	2318.48				Yellow if min<on hand<=ROL
4	49.9	50	46.08				Green if ROL<on hand
5	49.9	50	47.67
6
7
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C5	Expression	=$B2<$C2	text	YES
A2:C5	Expression	=$C2<$A2	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:C100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$C2<$A2

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[Skybluekid]

Try the below:

Book1.xlsm
	A	B	C	D	E	F	G	H
1
2		Min Stk	ROL	On Hand	Red	Yellow	Green
3		0	300	2298.48	FALSE	FALSE	TRUE
4		0	300	2318.48	FALSE	FALSE	TRUE
5		49.9	50	46.08	TRUE	FALSE	FALSE
6		49.9	50	47.67	TRUE	FALSE	FALSE
7
Sheet2

Cell Formulas
Range	Formula
E3:E6	E3	=D3<B3
F3:F6	F3	=AND(B3<D3,D3<=C3)
G3:G6	G3	=C3<D3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D6	Expression	=D3<B3	text	NO
D3:D6	Expression	=AND(D3<B3,B3<=A3)	text	NO
D3:D6	Expression	=C3<D3	text	NO