need help conditional format (if other cel is text => apply format pattern style

[Lennythelucker]

Hi all,

I hope somebody can help me, I have a conditinal format (*CF) question (Excel 2010). I know how this works with value, but not with text.

I have a worksheet with customers in the rows and weeks in the collums.
If a customer has a promotion a letter of the status appears + the promotion mechanisme.
I already use the folowing CF:
Cell value begins with "b" ==> Blue
Cell value begins with "d" ==> Red
Cell value begins with "v" ==> Orange
Formula: =ISERROR(" ")

Excample of the file:

...................1.....2.....3.....4.....5.....6.....7 etc
account 1 ..........D................. V1+1
account 2 ....D........... D promo ............ V
account 3 ..........D3for2 ........................D
account 4 ...............................D
etc.

I like to apply a conditinal format/ pattern style to all accounts from account 2 in the collum if there is a promtion / text in the week cell of account 1.

So it should look like this:

...................1.....2.....3.....4.....5.....6.....7 etc
account 1 ..........D................. V1+1
account 2 ....D....//..... D promo//............V
account 3 ........../D/3for2 ........//............D
account 4 .........//..................../D/
etc.

So I like to start in cell B76: if(b$75=text than /// (pattern style)

I hope somebody knows how to do this.

thanks in advance for your help.

Kind regards,

Lenny

 

[Lennythelucker]

I found it.

the formula must be =b$2>"d"

I don't know why =b$2="d" didn't work, but > works