Conditional formatting with cell column ranges

[Jadegirl]

Conditional formatting with cell column ranges

Is there a way to use conditional formatting for cell ranges - for example, I would like to color code major changes of 25% increase in purple and 25% decrease in orange.

I have column A with values I want to compare against Column B

For example:
column A column B Column C (Goal)
100 72 orange
200 180 do nothing
100 125 purple
100 124 do nothing
100 126 purple

I would like to try this in both the reg. excel & with pivot tables.
Also, is there a formula way to do the row and the cell?

Using Excel 2007

Thanks

 

[cstimart]

This should get you started.

Sub Color_Coding()
Dim LR As Long
Dim i As Long

LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To LR
    If Range("B" & i) <= (Range("A" & i) * 0.75) Then
        Range("C" & i).Interior.Color = 26367
    ElseIf Range("B" & i) >= (Range("A" & i) * 1.25) Then
        Range("C" & i).Interior.Color = 10498160
    End If
Next i

End Sub

 

[VoG]

Or with Conditional Formatting

Excel Workbook
	A	B
1	100	72
2	200	180
3	100	125
4	100	124
5	100	126
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =B1>=A1*1.25	Abc
B1	2. / Formula is =B1<=A1*0.75	Abc

 

[Jadegirl]

Thanks - can you help me a little. I have never used codes so I am a little nervous about doing it. Is there another way?

 

[Jadegirl]

Below is a picture of what I got and what I would like to get. Can you let me know what I am doing wrong?

ahhh.. not sure how to post pics...

 

[VoG]

You cannot post images like that. But images are not useful Try Excel Jeanie - link in my post http://www.mrexcel.com/forum/showpost.php?p=2818328&postcount=3

 

[Jadegirl]

I tried the formula below, but I can't get it to work with the outcome shown below. Thoughts to what I am doing incorrect?
Thanks