Formula/Formatting Help Needed

[Puddycat]

I would like to to get cell G1 to turn a specific color depending on the matched value value of E1 to the corresponding value in column I. Can someone please assist me with this?


E G I
7.5 ?? 2.1
3.1
3.2
4.1
4.2
4.3
5.1
5.2
5.3
5.4
6.1
6.2
6.3
6.4
6.5
7.1
7.2
7.3
7.4
7.5
8.2
8.3
8.4
8.5
9.3
9.4
9.5
10.4
10.5
11.5

 

[Puddycat]

This is not coming across right. Is there someway to attach my file?

 

[VoG]

Try using Excel Jeanie to post a shot of your sheet http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[Puddycat]

I would like to to get cell G2 to turn a specific color depending on the matched value value of E2 to the corresponding value in column I. Can someone please assist me with this?

Excel Workbook
	E	F	G	H	I
2	7.5	*	*	*	2.1
3	*	*	*	*	3.1
4	*	*	*	*	3.2
5	*	*	*	*	4.1
6	*	*	*	*	4.2
7	*	*	*	*	4.3
8	*	*	*	*	5.1
9	*	*	*	*	5.2
10	*	*	*	*	5.3
11	*	*	*	*	5.4
12	*	*	*	*	6.1
13	*	*	*	*	6.2
14	*	*	*	*	6.3
15	*	*	*	*	6.4
16	*	*	*	*	6.5
17	*	*	*	*	7.1
18	*	*	*	*	7.2
19	*	*	*	*	7.3
20	*	*	*	*	7.4
21	*	*	*	*	7.5
Sheet1

 

[Jonmo1]

You can use conditional formatting.
But you need to describe in more detail..
What is the threshold...?

If E2 is Greater than say 5, then turn the cell red?

 

[Puddycat]

The result in G2 will always have an exact match to one of the numbers listed in the I column. I have also shown the colors that cell G2 should change to.

Excel Workbook
	E	F	G	H	I	J
1
2	7.5				2.1	Green
3					3.1	Green
4					3.2	Green
5					4.1	Green
6					4.2	Green
7					4.3	Green
8					5.1	Green
9					5.2	Green
10					5.3	Yellow
11					5.4	Yellow
12					6.1	Green
13					6.2	Yellow
14					6.3	Yellow
15					6.4	Yellow
16					6.5	Yellow
17					7.1	Yellow
18					7.2	Yellow
19					7.3	Yellow
20					7.4	Red
21					7.5	Red
Sheet1

 

[Jonmo1]

You need 3 conditional formats

Condition 1:
Formula is
=E2>=7.4
Format for Red

Condition 2:
Formula is
=E2>=5.3
Format for Yellow

Condition 3:
Formula is
=E2>=2.1
Format for Green