Conditional Formatting

[aarti_rto]

Hi,
i have below data of what should be the standard minimum & maximum stock and actual available stock of the part.
i need to know how to highlight using conditional formatting the parts as conditions given below.
please help.

Part No	Min Stock	Max Stock	Actual Avl Stock
A	100​	110​	90​
B	80​	210​	205​
C	80​	310​	136​
conditions for formatting
Highlight "actual avl stock & Part No " in green if the "actual avl stock" is within the limit i.e. "min & Max"
Highlight "actual avl stock & Part No " in Red if the "actual avl stock" is less than "min stock"
Highlight "actual avl stock & Part No " in Yellow if the "actual avl stock" is more than "Max stock"

 

[Peter_SSs]

Try this. Select A2:Axx and apply the Conditional Formatting rules shown. Then select A2:Axx and use the Format Painter to apply to D2:Dxx

Book1
	A	B	C	D
1	Part No	Min Stock	Max Stock	Actual Avl Stock
2	A	100	110	90
3	B	80	210	205
4	C	80	310	336
CF Stock

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A4	Expression	=$D2=MEDIAN($B2:$D2)	text	NO
A2:A4	Expression	=$D2<$B2	text	NO
A2:A4	Expression	=$D2>$C2	text	NO

 

[aarti_rto]

Try this. Select A2:Axx and apply the Conditional Formatting rules shown. Then select A2:Axx and use the Format Painter to apply to D2:Dxx

Book1
	A	B	C	D
1	Part No	Min Stock	Max Stock	Actual Avl Stock
2	A	100	110	90
3	B	80	210	205
4	C	80	310	336
CF Stock

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A4	Expression	=$D2=MEDIAN($B2:$D2)	text	NO
A2:A4	Expression	=$D2<$B2	text	NO
A2:A4	Expression	=$D2>$C2	text	NO

hi,
can you please share video , i am using excel 2016 & unable to do the above said process.
thanks

 

[aarti_rto]

Try this. Select A2:Axx and apply the Conditional Formatting rules shown. Then select A2:Axx and use the Format Painter to apply to D2:Dxx

Book1
	A	B	C	D
1	Part No	Min Stock	Max Stock	Actual Avl Stock
2	A	100	110	90
3	B	80	210	205
4	C	80	310	336
CF Stock

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A4	Expression	=$D2=MEDIAN($B2:$D2)	text	NO
A2:A4	Expression	=$D2<$B2	text	NO
A2:A4	Expression	=$D2>$C2	text	NO

Thanks, got it.

 

[Peter_SSs]

Thanks, got it.

You're welcome.