If any cell in a range is blank question
I have two sheets in a workbook. One is a Summary sheet, and the next is
titled "Bldg 5".
What I am trying to make sure is that the range A1:K20 on the Bldg 5 sheet
has had data entered to them (ie, they are not blank).
The question that corresponds to Summary sheet A1 is "Has the data for Bldg
5 been updated?"
If ANY blank in Bldg 5's range A1: K20, then put a "NO" in Summary A1's
cell. If ALL of the Bldg 5 range had data in it, then put a "YES" in Summary
I also need A1 to update as data is entered into the Bldg 5 range
(a...Splitting a cell that has word wrap as the delimiter
I have an excel cell that has name on one line, then
alt+enter, address on the next line, then alt+enter,
state on the next line, etc...
I want to split them - I tried using Data Text to
Columns, but I can't figure out to use the Alt+enter as
Check other and place the cursor in the box, hold down Alt while typing 010
on the numpad, release the Alt key
"Leslie" <email@example.com> wrote in message
> Hi -
> I have an excel cell that ...Changing color of a range of cells dending up on a value in anothr
I need to change the color of a range of cell, depending up on the value in
another cell. I am using Excel 2003. And it allows me to give only 3
conditions when using conditional format. But I have 7 differnt conditions.
Thanks in advance for any help.
Unless you move to XL2007, you will need to use VBA. Here are some sites
that will help
Alternatively, there is an add-in here
"Srajes&qu...Text Box Linked To Cell
My goal is to have a text box that displays the contents of a particular
cell. How do I link the text box to the cell?
Make a Text Box from the drawing toolbar.
Select the box and in the Formula Bar, type = and
then select the cell, press enter. ( IE: =$C$5 )
The cell can also be on a different sheet, just do the same. ( IE:
> My goal is to have a text box that displays the contents of a
> cell. How do I link the text box to the cell?
Hi, we are implementing CRM and I cannot see an easy way of having the same
contact appear in the "My Active Contacts" view for more people other than
eg there are 5 people in my team and we all need to see the contact Joe
How do I do this please so Joe Bloggs appears in all my team's "My Active
I have already created a team called IT and shared Joe Bloggs to IT.
Less Spam Better enjoyable experience
Visit : news://spacesst.com
On Jun 29, 3:54=A0...Activated Outlook and lost all data on Outlook Express
When I downloaded Windows XP Patch 2 it included Outlook. I installed the
patch and activated Outlook. My old Outlook Express disappeared, along with
a lot of files that I hadn't read/responded to/saved. Is Outlook Express
still somewhere in my computer system? How do I access it to review and save
some of the files that were there?
If you use outlook 2003,
try to import data from outlook express to outlook 2003.
from menu of oulook 2003,
file > import & export > import internet mail and addresses > Outlook Express 4.x, 5.x, 6.x
"TeacherGuy"...Truncated Merged Cells
Actually, I have truly MERGED cells that contain LINKS to
other workbooks. The merged cells were created exactly as
you described and the data within them (text) comes from
several other workbooks, with the appropriate references.
We created them in 95 and later converted them to 97. We
can use them in Excel XP but they lose the data that would
be displayed on 2002 and 2003. Have not tried 2000 yet.
Thanks for the help. We are very concerned about this
problem. Our workbooks are complex with many links.
I only have the ideas that I already posted.
And you can find posts in goog...Is there a way to Sort Data by font color or cell shading?
I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status will
change and I will gray them out by just shading the background of the cell
Is there a way I can sort these items by the background/shading of the cell
first and then the secondary sort be date?
So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.
Take a look at this link:
http://www.cpearson.c...Distribute Campaign Activity: 401: Unauthorized
We've got an evaluation CRM site put together (CRM 3.0 Server) on
Windows 2003 Server/AD/SQL 2000.
We've got 10 or so clients testing heavily to see if it whats we want
from a CRM solution for our organisation.
Everything generally is running ok, despite our client PC's currently
not members of the domain (we are in a process of Novell>AD migration)
- and thus we've had to do various fiddles to get clients to talk to
the CRM server - such as caching of usernames/passwords on the
We're currently experiencing this on the Distribute Campaign Activity/
...Cell identity when printing comments on separate page
Operating System: Mac OS X 10.5 (Leopard)
When printing comments at end of page, it identifies the cell by letters and numbers. (i.e. Cell: AA33) Afterward the comment is shown for that cell. <br><br>Question: Instead of the cell identity being shown this way, is it possible ithe cell can also be identified by its X axis header for that column with the y access header for that Row. <br><br>Thank for your assistance. <br><br>Carl
Sorry Carl, but I'm not clear on what you're asking for... In 'MySpeak' ...Assigning a color to a cell
I saw some other post about kind of the same problem but not this way.
I have a risk evaluation formula in a cell. Output range is between 1 and 9
If between 1 and 3, I want to assign the color lightgreen to it
If between 4 and 6 I want to assign the color yellow to it
and red if 7 to 9.
Is this possible within the Function use ? If not, How can I apply that
automatically ? a macro ? How ?
See menu Format > Conditional format. It has a very helpful wizard.
(Remember to consider what should happen at exact numbers 3, 6, 9.)
HTH. Best wishes Harald
"Junkyard Engineer&qu...Inserting an image into a cell
Is there any way to insert an image (or a series of images) into a cell
rather than onto a worksheet?
unless they have changed something in 2007, about the only way you can do
that is insert it as a comment.
"Trent SC" wrote:
> Is there any way to insert an image (or a series of images) into a cell
> rather than onto a worksheet?
> Many thanks
Not into the cell but maybe you could use the comment to hold your image.
http://www.contextures.com/xlcomments0...Running macros for different cells at the same time
Is it possible to run different macros on different cells at the sam
time? If so how do I go about setting it up?
Message posted from http://www.ExcelForum.com
not really sure what you're trying to do. Could you give an example?
> Hi all,
> Is it possible to run different macros on different cells at the same
> time? If so how do I go about setting it up?
> Message posted from http://www.ExcelForum.com/
Yes it is possible to run different m...Word Wrap in Cells
Have a strange one. Have word wrap set to on in cell format and have
text in paragraphs (using alt-ret) within the cell. Some sentences (all
within the same cell)are wrapped but others aren't. Any ideas?
New one on me this. Many thanks, Shaun
if you have lots of text in your cell (>1000 characters) this could happen
"Shawk" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Have a strange one. Have word wrap set to on in cell format and ha...Splitting multiple cell contents from 1st column into 4 columns
n my first column I have 4 cells (1-4) (5-8) etc. with general content.
The content from each of these 4 cells needs to be placed in a separate
column to make a list that I can sort etc.
Example: COLUMN A
2 Heatherridge Road #301
3 Harry Smith
4 H25 Condo Fairfax Place
6 McGrath Street # 56
7 Mary Jones
8 B45 Condo Lemon Circle . . . . . . and so on and so on
every 4 cells.
I have hundreds of 4 cell descriptions. I just can't do this one by one.
Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though I
use it for e...Activate email column to hyperlinks
I have a colume of email addresses in an excel 2002 document. I need to make
them active hyperlinks - How ? Microsoft instuctinos are useless here.
can't they be converted in one batch to active hyperlinks so when the email
address is clicked on, the email program opens in a fresh email ?
Many thanks for any help
"DixieWins" <DixieWins@discussions.microsoft.com> wrote in message
> I have a colume of email addr...how read value from last selected cell? It is possible? how get adress last selected cell?
I write to cell A11 value "hello",
IF I click "ENTER" or IF I click mouse in any different cell (A15, B10,
C1... free choice) I wont to display:
MsgBox "Value in your last selected cell = ???"
On this example MsgBox "Value in your last selected cell = hello"
it is very important for me.
I try with event of Private Sub Worksheet_Change(ByVal Target As Range) ??
You have little choice but to use the Worksheet_Change() event as the
Worksheet_SelectionChange() event, give you the cell ...How do I pass series data x-value range to a chart from a cell?
I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have
two worksheet cells (B1 & B2) that contain the start and end date for the
x-axis of the chart. I want to be able to link the chart series data to the
start and end date values so that the chart automatically adjusts when I
change the dates in the worksheet cells. I can create a string or address for
the x-values but how do I do not know how to pass this to the chart series??
I know I can do this using a macro, but I want to do it without macros so
that friends who use MicrosoftCharts (the cheap, n...Is there a way to protect individual cells?
Hello, is there a way to protect individual cells? Thank you
amos79's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2759
View this thread: http://www.excelforum.com/showthread.php?threadid=47112
> Hello, is there a way to protect individual cells? Thank you!
Go to *Tools/Protection/Protect Sheet*
BenjieLop's Profile: http://www.excelforum.com/member.php?action=g...This one is tricky....Macro to save file as cell value x in direct
Two cells A1 & B2
I am trying to create a Macro to attach to a button to Save an .xls as
"A1".xls in directory R:/SALES/Team 318/"B2"
instead of typing it in all of the time....
Any helpers? Past attempts at this have failed.....the winner will get a big
Try something like:
Dim mypath As String
Dim sfile As Range, sdir As Range
mypath = "R:\SALES\Team 318\"
Set sfile = Sheets("Sheet1").Range("A1")
Set sdir = Sheets("Sheet1").Range("B2")
ThisWorkbook.SaveAs Filen...in VBA how to retreive cell values 1 byte at a time?
How would I write VBA to retrieve (get at) the value in a cell byte by
byte from its natural form? i.e. no conversions are to be performed.
E.g., if a string, then I may get more bytes than for a number.
If the cell contains text, you can retrieve characters (bytes) with the MID
=MID(A2, CharPosition, 1). You can get the actual byte values with the CODE
=CODE(MID(A2, CharPosition, 1)).
If a number, you can extract the decimal digits of the number in the same
way, but you're not getting actual bytes (as stored by Excel). Excel stores
numbers in ...Can I format an entire row based on the value of a single cell?
I would like to use the conditional formatting feature to format an entire
row rather than just a single cell. For example: If the cell value = "Total"
then the entire row is bold.
select your range (multiple rows???).
Then with A3 (say) the activecell in that selection:
apply a nice format
> I would like to use the conditional formatting feature to format an entire
> row rather than just a single cell. For example: If the cell value = "Total"
> then the entire row is bo...cell address combination
I'm using regular Excel formula in the cells (not scripting, mainly
because I don't know how). I have a problem with trying to combine
offset() and small()
my actual code is:
and it obviously doesn't work.
Is there any way to use those two features together?
If it helps I'm trying to make a gradebook capable of weighting
categories (e.g. 50% of avg for quiz, etc.) and dropping lowest
quizzes. I have all the code working except this one combination of
finding the lowest grade using small() and returning its corresponding
number using offset().
...Macro entering data into a protected Cell??
I'm trying to create a time sheet and I want to have a macro insert the
current time into a protected cell (to stop people editing the time
Is this possible?? Any tips/hints
See your other thread
Regards Ron de Bruin
<email@example.com> wrote in message news:firstname.lastname@example.org...
> I'm trying to create a time sheet and I want to have a macro insert the
> current time into a protected cell (to stop people editing the time
> Is this possible?? Any tips/hints
...How to add time from multiple cells & date Cells & machine type c
I'm trying to add up the amount of machinery downtime from a number of
different cells but the thing is that I need to only have it added up by the
date set in another cell (Which can have multiple cells of the same date) as
well as the specific name of that machinery in another cell(which can also
have multiples of the same machinery name). How can i get to just add up for
that specific date, machine name, and time.
Date (Cell 1A thru 50A) Machinery Name(Cell 1B thru 50B) Downtime(Cell 1J
Column A ...