Some help with conditional formatting

[Jon Parker]

Hi,

I have a worksheet which details stock and last weeks sales.

e,g, column A is stock, column B is 7-day sales. This extends down the
worksheet several hundred lines (1 line for each product I sell)

I want to put in a conditional format which will turn Column A red if it
is less than column B.

I have no difficulty in doing this with one cell, however I can't seem
to paste this into another cell or range of cells using copy/paste
special or the format painter. When I do paste into another cell the
condition is copied exactly.

What I want to do is write a condition where the cell being interrogated
is not referenced absolutely, but relatively, in essence what I need to
a conditional format which does "if the cell to the left is less than
this cell, turn red".

Hope that makes sense, thank for any help.

 

[Bob Phillips]

Select ball of the cells (yes, all several hundred lines over columns a and
B)

In CF, add a formula of

=A1<B1

and format

--

HTH

RP
(remove nothere from the email address if mailing direct)