software

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: www.excelforum.com/member.php...oamp;userid=32760
View this thread: www.excelforum.com/showthread...hreadid=525921
Is the increase based on column F?--
Infinity
------------------------------------------------------------------------
Infinity's Profile: www.excelforum.com/member.php...oamp;userid=32725
View this thread: 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
quot;Cell value isquot; and quot;Greater thanquot; and paste:

=$F2*1.03

Curiously, the equals sign appears to be necessary.

Good luck--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=525921
John James Wrote:
gt; Try this. Assuming E2 is the first cell with an amount. Highlight the
gt; cells from E2 downwards, select format-conditional formatting, select
gt; quot;Cell value isquot; and quot;Greater thanquot; and paste:
gt;
gt; =$F2*1.03
gt;
gt; Curiously, the equals sign appears to be necessary.
gt;
gt; Good luck

Worked a treat

Thanks a lot--
forbsey
------------------------------------------------------------------------
forbsey's Profile: www.excelforum.com/member.php...oamp;userid=32760
View this thread: www.excelforum.com/showthread...hreadid=525921