days of the week

[sasa]

I have a range of items from j14 ->44-
I want the user to enter his items down column from j14 to j44

If the item that is entered in column j is like this (clin1, clin2, clin3,clin4) matches a particular day of the week in the coulumn b like Monday, Thuesday, Thursday, Friday) I would like that J cell to turn red
Thanks.

[Bob Phillips]

How do you construe something like clin1 to match a day of the week? I see no connection.

[sasa]

How do you construe something like clin1 to match a day of the week? I see no connection.

[sasa]

Sorry, match is not the correct word. Maybe link. In other words in column b may appear Monday or Thuesday orThursday or Friday in column J clin1 or clin2 or clin3 or clin4

Thanks

[mdmackillop]

I don't understand Match or Link in your question. Can you post an example showing what should be Red and a note explaining why.

[Bob Phillips]

Match was not the problem word, it was the connection between the text (clin1 etc) and the days of the week.

[sasa]

Here is my example. The cell gets red only when clin1,2,3,4, meet some days of the week
Thanks

[Bob Phillips]

Use a formula in CF of

=AND(LEFT($H1,4)="clin",$A1<>"Saturday",$A1<>"Sunday")