Good to hear.

Thanks for the feedback.

You can learn more about the usage of the $ signs by looking at
relative and absolute cell addresses in help.


Gord

On Tue, 14 Feb 2012 00:25:52 -0000, "Ian R" wrote:



"Gord Dibben" wrote in message
.. .

Preselect A through J for as many rows as you would be using.

For example select A1:J100

Set up your conditions for Column A like Use a Formula =$A1="Paid"

then format and =$A1="Unpaid" then format

Make sure you use the $ sign as I have shown which locks the column
but allows the row to increment down to row 100


Gord
=============================

Gord

Thank you very much. That was just what I needed.

Ive now got it working exactly how I want it.

Cheers

Ian