Hi.

I have a college asignment and I need to apply conditional formatting
to show if a value has increase by more than 3%. I have cells similar
to the following:

E F
30 27
98 95
48 47
40 35

I need to apply conditional formatting to the cells in E column, if
they have increased by more than 3%.

Any suggested solution would be _greatly_ appreciated.


--
forbsey
------------------------------------------------------------------------
forbsey's Profile: http://www.excelforum.com/member.php...o&userid=32760
View this thread: http://www.excelforum.com/showthread...hreadid=525921

Is the increase based on column F?


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=525921

Try this. Assuming E2 is the first cell with an amount. Highlight the
cells from E2 downwards, select format-conditional formatting, select
"Cell value is" and "Greater than" and paste:

=$F2*1.03

Curiously, the equals sign appears to be necessary.

Good luck


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=525921

John James Wrote:
Try this. Assuming E2 is the first cell with an amount. Highlight the
cells from E2 downwards, select format-conditional formatting, select
"Cell value is" and "Greater than" and paste:

=$F2*1.03

Curiously, the equals sign appears to be necessary.

Good luck

Worked a treat

Thanks a lot


--
forbsey
------------------------------------------------------------------------
forbsey's Profile: http://www.excelforum.com/member.php...o&userid=32760
View this thread: http://www.excelforum.com/showthread...hreadid=525921