Conditional formatting on cell a12 if cell b12 contains text "[b]"

[MrKLaw]

To Forum Users,

I have read up on conditional formatting and looked through it on excel however i have only been able to conditionally format the cell that is targeted for the query.
What i mean is if cell b12 contains text "" then cell b12 is conditionally formatted to what i set it to.

Im looking to have my cells A12 to be conditionally formatted to 0.### "[BOX]" if cell B12 contains the text
And this is to be repeated A12:A28 with B12:B28

PLease could anyone help me on this?

Regards
Kai

 

[etaf]

for 2007 or 2010 excel version
Conditional Formatting


Highlight applicable range >>
A12:A28


Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:



=B12=""



Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[MrKLaw]

does the =B12="" work when there are other texts in the box b12 amongst the ?

 

[etaf]

No
Is the in a particular position ?
or can it be anywhere in the cell text ?