Conditional formatting of text cells

Terry M · Jan 14th, 2002, 01:52 PM

Fabulous Site! I've learned tons while looking to solve these 2 similar problems: 1. Using conditional formatting I would like to highlite cells in a range containing specific text (within text), and 2. again using conditional formatting I would like to highlite cells in a row that have more than one occurrence of the same specific text (within text). Seperate issues. This is a baseball schedule containing team references in the cells ie: "A1 vs B3", "C6 vs A2" etc, I am trying to highlight cells containing a specific team in a range of cells ie: "A2" for question 1, and highlight multiple occurrences of cells containing "A2" in a row for question 2.
Very much appreciated and again - fabulous site!

Aladin Akyurek · Jan 14th, 2002, 02:29 PM

Quote:

On 2002-01-14 12:52, Terry M wrote:
Fabulous Site! I've learned tons while looking to solve these 2 similar problems: 1. Using conditional formatting I would like to highlite cells in a range containing specific text (within text), and 2. again using conditional formatting I would like to highlite cells in a row that have more than one occurrence of the same specific text (within text). Seperate issues. This is a baseball schedule containing team references in the cells ie: "A1 vs B3", "C6 vs A2" etc, I am trying to highlight cells containing a specific team in a range of cells ie: "A2" for question 1, and highlight multiple occurrences of cells containing "A2" in a row for question 2.
Very much appreciated and again - fabulous site!

You mean to highlite each cell that contains the team A2? If so, select the target range, activate Conditional Formatting, choose Formula Is for Condition 1, enter as formula (assuming that your range E2:H60),

=COUNTIF(E2,"*A2*")

activate Format, select a color on the Patterns tab, click OK twice.

Note: I can't see your post listed. I arrived here by using the Search facility, not an easy way of interaction.

[ This Message was edited by: Aladin Akyurek on 2002-01-14 13:38 ]

[ This Message was edited by: Aladin Akyurek on 2002-04-15 08:43 ]

Terry M · Jan 14th, 2002, 03:10 PM

Thanks very much. It's often an easy solution - I was trying formulas much more complex than that - but your basic one works well!

I have no idea why my post isn't viewable. I'm new on the board as you can see. I did notice that when I posted it the date was several months out of whack.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 01:52 PM	#1
Terry M New Member Join Date: Jan 2002 Location: Victoria BC Posts: 2	Fabulous Site! I've learned tons while looking to solve these 2 similar problems: 1. Using conditional formatting I would like to highlite cells in a range containing specific text (within text), and 2. again using conditional formatting I would like to highlite cells in a row that have more than one occurrence of the same specific text (within text). Seperate issues. This is a baseball schedule containing team references in the cells ie: "A1 vs B3", "C6 vs A2" etc, I am trying to highlight cells containing a specific team in a range of cells ie: "A2" for question 1, and highlight multiple occurrences of cells containing "A2" in a row for question 2. Very much appreciated and again - fabulous site!

Jan 14th, 2002, 03:10 PM	#3
Terry M New Member Join Date: Jan 2002 Location: Victoria BC Posts: 2	Thanks very much. It's often an easy solution - I was trying formulas much more complex than that - but your basic one works well! I have no idea why my post isn't viewable. I'm new on the board as you can see. I did notice that when I posted it the date was several months out of whack.