Conditional Formatting 3 based on cell values

[appleeye]

Hello all,


Can someone please help me with the following:


I need to look at 3 cells then colour one of them depending all values.

I.E. cell A1=10000, B1= 5.7 and C1=a symbol like >>.


So i need B1 to change to green if A1= between 5000 and 15000 and B1 is less than 6 and C1=>>


Thanks - looks simple ,....but then so am I.


Risso

 

[Momentman]

For B1, you can use a formula like this, if i understood you correctly

=AND(AND($A$1>5000,$A$1<10000),$B$1<6,NOT(ISERROR(SEARCH(">",$C$1))))

 

[appleeye]

Thanks, but no joy.


I have changed it a little so my simple mind can work with it.
Now I only need:

IF A1 is greater than 50,000 and B1 is more than 5, then turn B1 red.

Any help is appreciated...thanks in advance.

 

[Momentman]

thanks, but no joy.


I have changed it a little so my simple mind can work with it.
Now i only need:

If a1 is greater than 50,000 and b1 is more than 5, then turn b1 red.

Any help is appreciated...thanks in advance.

=and($a$1>50000,$b$1>5)