Might be Formatting

[Guest]

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.

 

[Bob Phillips]

Select A1:L500
Goto menu Format>Conditional 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)

 

[Davy]

Hi, Hazel.
1.Select the range to set conditional formatting: select A1:L500 or just
type:A1:L500 in the name box which is left to the formula box.
2.Set conditional formatting: choose "formula" from the left combobox and
enter the formula: =$M1="P" on the right.

Hope you can understand what I said.
BTW, It's my first letter in this newsgroup.

Davy

 

[Susan]

yes you can use conditional formatting...........

highlight a1:m1 & click conditional formatting
choose "formula is"
and paste this formula in
=ISTEXT($P1)
select your formatting (in this case, shading).
then copy row a1:m1
& paste down through row 500 using paste special - paste formats.
then when you enter ANYTHING in column p, the whole row
will shade whatever color you choose. if you want it to also include
column p, then select a11 before you conditionally format.
hth!
susan

 

[Guest]

Pick any cell in row 1 and enter conditional formatting:
Foumla is
=$P1="P"

then copy this cell and paste/special/format across the row. Then copy the
formats for any other rows.

 

[Guest]

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

Select A1:L500
Goto menu Format>Conditional 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)

 

[Bob Phillips]

Shouldn't that be t'internet <bg>

Thanks everybody

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

 

[Guest]

Hi Bob

Ooop's typo
--
Many thanks

hazel

Shouldn't that be t'internet <bg>

 

[Bob Phillips]

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

Bob