conditional formating with IF values

[markan667]

hey folks i need a formula to achieve next:

in collumn A there are up to 15 different inputs (text) and in collumn B are numbers, i need to format the B collumn values so that the numbers turn red IF a certain text is in that row in collumn A

hope you understand the question...

 

[drsarao]

No IF is needed.
Select the whole column B (or range you want to set format to). B1 MUST be the active cell.
Format --> Conditional Foormat.
In the Conditional formatting box:
In the left dropdown choose "Formula is"
Enter the following formula: =A1="certain text"
(the first "equals" sign is also required.)
Select the Font format.
Done.
When A1="certain text", the condition becomes true and format will be applied.

 

[markan667]

thanks for the answer, that works so far but i need one more rule for collumn B, for example if the text in collumn A is CAR in collumn B the text should go red ONLY if the number is less then 50 if it's 51 it can stay black...

 

[drsarao]

Try:
=AND(A1="CAR",B1<=50)