Color a bar RED based on a value being "RED"

[jkalpus]

Greetings! I need to have Excel format a bar as red if a value in the table is "red." For example:

In cell A1, A2, A3, I've got Rep / % / Team
In cell B2, B2, B3, I've got Steve / 90 / blue
In cell C1, C2, C3, I've got Bob / 40 / blue
In cell D1, D2, D3, I've got Phil / 65 / red

I want Excel to format Steve's bar to be BLUE, because he's a member of the "blue" team. I'd like the other bars to be similarly formatted in blue and red.

Any ideas?

Thanks for thinking! - John

 

[Peter_SSs]

1. Select all of rows 1,2 and 3 by clicking and dragging in the row labels area.
2. Apply the Conditional Formatting shown (iF you need help with how to do this, post back)

Excel Workbook
	A	B	C	D	E
1	Rep	Steve	Bob	Phil
2	%	90	40	65
3	Team	Blue	Blue	Red
Conditional Formatting

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =A$3="Blue"	Abc
A1	2. / Formula is =A$3="Red"	Abc