Conditional formatting or formula to green/red cells based on a value?

[excelos]

Hello!

How can I use conditional formatting or formula to green/red cells based on a value?
The conditional formatting does not allow me to specify more than one criteria, and I need to either green or red the cell based on if the value is equal/above or below another cell's value.

Thanks!

 

[Ramballah]

U can make multiple conditional formats in a cell / range.

=	is equal to
<>	is different than
<	is less than
<=	is less than or eual to
>	is greater than
>=	is greater than or equal to

<tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">
</tbody>

Hope this helps you