Might be Formatting
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
|