Formula Help?

E

ezeetyger

I am not that good with Excel so please bear with me.....

I have a column which lists prices quoted and another column which
lists the actual price. What I have to do is figure out a formula
that will compare column 1 (price quoted) with column 2 (actual price)
and if column 1 is 5% or more lower than column 2 I need it to
identify it ie maybe turn it red or something

Column 1 Column 2
Quoted Actual

£100 £120
£200 £250 !
£300 £300
£400 £550 !

I simply have no idea how to do this and am struggling as I do not
understand formulas, can anyone pleae help me

Many thanks in advance
 
J

jeff

Hi,

Use Conditional formatting on your quoted cells:

Select Cell A1; then
Menu-Format-Conditional Formatting; select "formula is"
in the first box; then enter =A1<B1*0.95 in the next
box; select "format..." and choose your format (say, red);
Ok out. then use the formatting paintbrush to format
your other cells in A.

Jeff
 
Top