 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / February 2007Might be Formatting
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.  SignatureMany 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 Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hi All > [quoted text clipped - 8 lines] > up or in default. Tried Conditional Formatting but it won't let me use a > range for some reason beyond my capabilities. Thanks everybody My gaffer thinks I'm brill -- little does he know -- I know some great Excel programmers out there on thinternet. SignatureMany thanks hazel > Select A1:L500 > Goto menu Format>Conditional Formatting [quoted text clipped - 18 lines] > > up or in default. Tried Conditional Formatting but it won't let me use a > > range for some reason beyond my capabilities. Shouldn't that be t'internet <bg> > Thanks everybody > [quoted text clipped - 29 lines] >> > a >> > range for some reason beyond my capabilities. Hi Bob Ooop's typo SignatureMany thanks hazel > Shouldn't that be t'internet <bg> > [quoted text clipped - 31 lines] > >> > a > >> > range for some reason beyond my capabilities. That was my leg-pull, I assumed, but wasn't sure, that you were from 'Up t'North'. Bob > Hi Bob > [quoted text clipped - 39 lines] >> >> > a >> >> > range for some reason beyond my capabilities. 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 "Hazel" <Hazel@discussions.microsoft.com> дÈëÏûÏ¢ÐÂÎÅ:03CE4284-A2B9-4560-AEB3-EA7EFE1144B7@microsoft.com... > Hi All > [quoted text clipped - 8 lines] > up or in default. Tried Conditional Formatting but it won't let me use a > range for some reason beyond my capabilities. 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 a1:p1 before you conditionally format. hth! susan > Hi All > [quoted text clipped - 11 lines] > > hazel 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. SignatureGary's Student gsnu200705 > Hi All > [quoted text clipped - 6 lines] > up or in default. Tried Conditional Formatting but it won't let me use a > range for some reason beyond my capabilities. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.