PDA

View Full Version : I Need Help Conditional formatting in cell



etheer
08-25-2014, 09:01 PM
Hi
I Help Change Color Cell To Green By Three Conditions In The Cell
I Use This But Dot Working

=IF(O7>0%;O7>Q7;F7>0%)

Please Help Me

etheer
08-25-2014, 10:12 PM
:banghead::crying:

mancubus
08-25-2014, 11:38 PM
if you want to test a value against multiple conditions use AND or OR operators.

i think you can spot the difference between these operators.


=AND(O7>0%;O7>Q7;F7>0%)

etheer
08-26-2014, 10:31 AM
if you want to test a value against multiple conditions use AND or OR operators.

i think you can spot the difference between these operators.


=AND(O7>0%;O7>Q7;F7>0%)

Thank you working

mancubus
08-26-2014, 02:53 PM
you are welcome.
pls mark the thread as solved from thread tools.