Fill down conditional formatting series
This surly is a simple question with a equally simple answer.
B1:B10 require the following formula:
and so on
when I format B1 and fill down the B1 is still referenced
Conditional formatting automatically assigns the CF formula to all the cells
within the seleciton. Select the cell/Range (say B1:B10). Please note that
the cell reference B1 mentioned in the formula is the active cell in the
selection. Active cell will have a white background even after selection
If this post helps click Yes
"gootr...Conditional Formatting #44
How do you get text in cell A1 to appear in a bold font if a dat
appears in cell B1?
Can this be done in conditional formatting, if so, how
Message posted from http://www.ExcelForum.com
The following will recognise a _value_ in B1 and make A1 bol
Select A1 and click Format > Conditional Formatting.
Choose Formula is (instead of Cell value is) and put in the bo
=$B$1<>"" . This says B2 is not empty.
Click Format... and choose Bold. OK. OK.
A date is just a number with a particular format. If your need is t
spot an entry (rather than a blank) in col ...Numeric currency to words
I would like to use a user created function to read a cell containing a
numeric currency value and put it into words, ie. $103.40 is One Hundred
Dollars and Forty Cents. Any help? Thanks!
Here is one way (you would want to use "Dollar" as the second argument to
Go into the VB Editor (Alt+F11) and add a Module to the Workbook
(Insert/Module from the VBA menu) and then paste in all of the code
appearing after my signature into the Module's code window. You can call the
function from your work sheet like this =NumberAsText(A1) where A1 is
assumed ...How to make staff sales report and stock report
First table with names. second table with store items.
I read the northwind for preparing invoices which does not fit my requirement.
Pls give me links for me to read up on how to prepare report on persons who
have made purchases by linking these two tables.
Pls give any links where I can read on how to go about to prepare a report
on persons who made purchases; report of stores opening stock, quantity sold
and stock balance etc.
On Wed, 19 May 2010 10:09:01 -0700, CAPTGNVR
>...Expected shipments report for drop ships only
I'm trying to run an expected PO shipments report for drop-
ships. Report writer is able to accept the restriction
for showing only Standard POs by entering the restiction
PO Type = 1.
But the report does return any records if you use PO Type
= 2 or <> 1. The report shows Drop Ships only if you are
in Report Writer, but not if you access the report in
Great Plains. And yes, I've checked security.
How do I print the expected shipments PO report from GP
(not report writer) for Drop Shipment POs only?
...dang cell format
I'm trying to set an Excel cell format like I can do in Access to prevent
Cell input is 1234-123-1234-123, that's to say, non-sequential numbering but
using 4 numbers dash, then 3 numbers dash, 4 numbers dash, then 3 numbers.
If the entry is wrong, go to halt/stop.
What hasn't worked;
1. conditional format
2. Format, cells, 'custom'
I've tried ####-###-####-### under custom but it fails because it
allows more then 4 numbers at the very start.
I "can" get, 123456-789-1234-234 The last 3 sequences work but
not the 1st seque...pipe delimited format
how do i save a spreadsheet in pipe delimited format?
i am using excel 2002, thanks
Here's one way, works well if you only need to do it a couple of times!
Save as a csv.
change the extension of the csv to txt
open the file, select all and copy
paste it into word
use replace to replace "," with "|"
select all, copy and paste back into the text file
If you have to do it numerous times your best bet is a macro, post back if that's what you need
"rick" <firstname.lastname@example.org> wrote in message news:email@example.com...
>...Update a Report from a Form
I have a button on a form that opens a report based upon that form. I want to
be able to change the data in the record, then simply click the button to
update the report. The button needs to update the record (without moving to
the next record), close the last report if it is still opened, then open the
new report (or simply update it)
...Crystal Reports 9 timeout 10-14-04
When creating a report using Crystal Reports Wizard in Crystal Reports 9,
Crystal seems to just hang indefinitely.
What version for Crystal reports you are using ?. You should be using
Crystal Reports 9.0.22. Please follow the link regarding Crystal.
We are using 9.2.2 - the correct version.
> What version for Crystal reports you are using ?. You should be using
> Crystal Reports 9.0.22. Please follow the link regarding Crystal.
>...Cell color change without using conditional formatting
I have a multi-tab workbook with several checklists.
Once item on list is complete owner puts YES in status box and cell turns
I have a combined list of all the tabs on another sheet.
I need the combined list to pull the YES response from each individual
checklist tab and also turn Green.
Conditional formatting will not allow cross worksheet actions. Is there
another way to pull all the YES data into the overall checklist?
Conditional Formating WILL allow cross worksheet actions, but the cell(s)
referenced on the other worksheet must use an Excel Name
(Inse...help with header row format
The first row in my excel file is the header. When I insert a new row after
that, the new row takes the format, color etc of the header. How can I avoid
the new rows inserted form taking the format of the forst row?
If it's Excel 2003, when you insert the new row under the header row youy
should get a small icon appearing which has a drop down arrow providing
format options. You can select to format the new row as the line above, the
line below, or clear formatting.
> The first row in my excel file is the header. W...2007 Excel Table and Pivot Table Formatting
Just wondering why when I use the standard formatting (ie design ) designs
in excel 2007 for tables and pivot tables, when I send this to someone that
does not have excel 2007, they get this with no colour, no bold subtotals
...Database text converted to numeric
I Imported data from a SQL Database, it is numeric and alpha numeric but
mostly numeric numbers (Serial numbers). I need to compare this list to
another Excel list containing the same information but with some
numbers missing. I pull this into Access and when I try and compare
them the error is that the format has to be the same.
I changed the format of the list I imported to Numeric (most of the
numbers is only numbers) but now I have to press F2 and enter on every
single number (database is only 227500 lines) to convert it to a
I thought it was because it still saw itself as a Dat...Format Axis #2
I am doing a project ion school and i have to make a population pyramid. I
have filled out all the data with males being negative. I have the chart
Wizard up and on my school sheet it is asking me to dounble click on the
verticel axis, Format Axis should appear but I can't seem to get it.
If you are using Excel 2007, you will have to right-click and select 'Format
Axis...' Double-clicking should work in older versions of the program.
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-c...exporting reports to email
I am trying to export reports directly to email in html format. When I click
export I get a 'Microsoft Office Outlook' box "The operation failed". Click
OK and a 'Store Operation Manager' box appears with "Export Failed". Click OK
and back to my active report. I can export to desktop and then email by
attach ment but would rather do it in one step. Thanks for any suggestions.
On Oct 29, 9:13 am, astro <as...@discussions.microsoft.com> wrote:
> I am trying to export reports directly to email in html format. When I click
> export I ...Random Conversion of alpha/numeric text with letter "e" to exponen
OS - w2003, office 2003, desktop XP Pro/ w2000 Pro
My company uses a six digit alpha - numeric string for customer account
a few are all numeric, most are in the format: ##X###, where # = numeric and
X = an alpha character.
A few accounts, 101 out of 360, that contain an "e" as the alpha character
are converted to an exponential by Excel. the other 259 are not. These 101
accounts where the first accounts created using "e", the subsequent 259
accounts are not converted by Excel.
Anyone have a clue as to what is going on and how I can stop it?
--...A FREE new 12-page special report on Asian and Indian Stocks
A FREE new 12-page complimentary special report on Asian and Indian
stocks, has been released by Elliott Wave International.
Investment Opportunities for Asia's Big 6 Markets will give you
specific forecasts and valuable commentary and observations for the
Japan's Nikkei 225
Hong Kong's Hang Seng & MSCI
China's Shanghai & Shenzen
Singapore's Straights Times
Australia's ASX 200 & All Ordinaries
This FREE 12-Page Report was written by an analyst who lived in Asia
for most of the 1990s and knows the ...Conditional data point formatting with variable conditions?
I checked out Jon Peltier's great example/tutorial on conditional
chart formatting. I would like to conditionally format data points of
a scatter plot but the difficult thing about it is that the min-max
conditions are variable.
I have two data columns, x and y, yielding the scatter plot (Side
note: In the thread "Diagonal line in scatter plot?" I described the
data in a bit more detail.). The conditions for giving a data point a
certain color are not supposed to be fixed values but instead the
ratios of x and y. Let's say the ratio of x any y is above 1.5 or
below 0.7, ...Automated Report Queue
Has anyone managed to find a way to generate multiple reports from RMS on a
scheduled, auto-run basis? There are several RMS reports I would like to
run each night, but it's a pain to have to go into each report and run them
individually. I would rather setup a report queue that runs every night at
a set time.
Anderson Plywood Sales
Culver City, CA
We have not found a way to do this...however if you are using Crystal
Reports for analysis, there is a component called Crystal Enterprise that
does scheduling and delivery.
However......Adding New Cell Formats
I have added a few custom Cell formats to the list given with Excel. #,##0 etc.
I have adde 0) and (0) etc.
Is there a formula I can write to enter feet and inches so I don't have to
use ' & " everytime I enter.
I have to type 1'-2". Is there a way I can format the cell so I just have to
enter 1-2 or something short like that?
...sorting alpha numerics
I have a list of documents that I need to sort by title. Example
After I sort, the list looks like this
How do I make it take the entire alphanumeric into account?
Let A2:A4 house the sample to sort.
In B2 enter & copy down:
Sort A2:B4, with column A in ascending order and column B in descendin
> I have a list of documents that I need to sort by title. Example
> After I sort, th...How do I format cells so that room numbers such as 1402, 1405a will sort correctly?
I'm trying to fix an Excel spreadsheet for a health care facility so that it
can sort data by the first column, whci is the patient's room number. Room
numbers can be pure numerical, or have a suffix at the end (a or b). So I
have e.g. room numbers 1306, 2204, 1401b, 1613, 1402b. At the moment, the
column sorts so that all the room numbers with a suffix follow all the
numbers without a suffix. I've formatted the cells as General, Numbers, or
Text, and get the same sort result each time. How can I fix this? HELP!
All help gratefully received and acknowledged.
Dan E...Tax report not exporting to Excel
I have the "Tax related Transactions" report set for the following:
Rows & Columns:
Columns - Payees
Type - Summary
View as a report
All taxable accounts (IRA/401(k) accounts unchecked)
Relevant taxable categories
Previous Year (1/1/2004-12/31/2004)
When I click Export to Excel, I type in the file name. Money.exe goes
to 100% and that's it.
If I change the COLUMN option from Payees to Totals Only, it works.
Otherwise I have to kill Money and reopen it.
I have run the SuperSalvage. No joy.
Office 2003 SR1, all fixes.
Windows XP Sp2, all f...text form to numeric ?
E.g A cell contain 1233- but the value is actually a numric value whereby
the "-" behind is a negative sign, wat function do I use to convert it to a
numeric form causing it to to become -1233 ?
One way, assuming that the values are mixed (some with/without "-" sign)
and that the values are in colA, which is formatted as text;
"crapit" <firstname.lastname@example.org> wrote in message
news:OSAgKf$1DHA.2324@TK2MS...Conditional Formatting Question #6
I want the formattin of a series of cells to be dependent on the data i
another cell. For instance, if A1 is a result of "something" then A1:A
will all turn red. How do I get that done?
livifivil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3691
View this thread: http://www.excelforum.com/showthread.php?threadid=56628
On Sat, 29 Jul 2006 12:31:02 -0400, livifivil
>I want the formattin of...