That was my leg-pull, I assumed, but wasn't sure, that you were from 'Up
t'North'.

Bob



"Hazel" wrote in message
...
Hi Bob

Ooop's typo
--
Many thanks

hazel


"Bob Phillips" wrote:

Shouldn't that be t'internet <bg



"Hazel" wrote in message
...
Thanks everybody

My gaffer thinks I'm brill -- little does he know -- I know some great
Excel
programmers out there on thinternet.

--
Many thanks

hazel


"Bob Phillips" wrote:

Select A1:L500
Goto menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$M1="P"
Click Format
Select the Pattern tab
Choose a colour
OK
OK

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Hazel" wrote in message
...
Hi All

We have a worksheet that lists Customer invoices the breakdown is
from
Column A to Column M and rows 1-500 and every month we send an
invoice
to
each customer. In Column M when the customer settles their invoice I
enter
the letter P in the cell, so that we know its been paid. It would be
a
time
saver after entering the Letter P if all the Cells A:L on that row
would
change colour. A quick scroll down to row 500 would then tell us who
was
paid
up or in default. Tried Conditional Formatting but it won't let me
use
a
range for some reason beyond my capabilities.









--
Many thanks

hazel