Formula/Formatting Help Needed

P

Puddycat

New Member

Joined

Aug 10, 2007

Messages

42

• Sep 2, 2011

• #2

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

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Sep 2, 2011

• #3

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

 

Upvote 0

P

Puddycat

New Member

Joined

Aug 10, 2007

Messages

42

• Sep 2, 2011

• #4

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

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Sep 2, 2011

• #5

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?

 

Upvote 0

P

Puddycat

New Member

Joined

Aug 10, 2007

Messages

42

• Sep 2, 2011

• #6

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

 

Last edited: Sep 2, 2011

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Sep 2, 2011

• #7

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

 

Upvote 0