Conditional formatting

F

forbsey

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.
 
E

edcosoft

Type CF formula in E-1 =F1>1.03*E1 then pick formatting. Copy down
your column E to end. ed
 
J

John James

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
 
F

forbsey

John said:
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
Click to expand...

Worked a treat

Thanks a lot
 
Top