eg. value 1 and 2 in a cell should make an entire row red
目前分類:title (3013)
- Dec 18 Mon 2006 20:34
highlighting rows according to a input value?
- Dec 18 Mon 2006 20:34
Last row value to another sheet
On one worksheet, I have several rows. Each time a new row of data is added,
I need to take the value from column B in the last row and display it in a
- Dec 18 Mon 2006 20:34
Pivot table problems
I'm trying to create a pivot table and I'm having problems with 1
field. The error message reads:
- Dec 18 Mon 2006 20:34
Numbered Lists
I am relisting this topic in the hope that someone will be able to
help.
- Dec 18 Mon 2006 20:34
Comments in Excel saved to HTML
Created a workbook that I saved to HTML. The comments that were created for
certain cells now show up with the comment indicator changed to a numbered
- Dec 18 Mon 2006 20:34
Formula to find highest alphabetic name in a list of names
Hi,
- Dec 18 Mon 2006 20:34
Running Schedule
I have a running schedule with mutlile tasks scheduled for different day # or
the same and would like to have the dates auto fill in once I enter the start
- Dec 18 Mon 2006 20:34
Prevent Username Accessing Workbook
I have a shared workbook which is used by several people. I would like to
prevent one particular username (the one set it Excel properties) from
- Dec 18 Mon 2006 20:34
Excel ? Formula for moving average
Bottom Qtile410 is the answer (formula is =MIN(C386:C486) )
based on 52
- Dec 18 Mon 2006 20:34
how to use the IF formula with a range of cells
I have a text in one cell (J2) and have to compare it with text in a range of
cells (B2:B999) to return an expression if true. I have tried using the IF
- Dec 18 Mon 2006 20:34
cHARACTERS BEFORE THE SPACE
- Dec 18 Mon 2006 20:34
Excel file window won't open
When I open my Excel software I can't open the file listing window. The
program hangs up and does not respond. The same thing happens with Word.
- Dec 18 Mon 2006 20:34
Criteria problems in the DSUM function
I have an excel sheet with three worksheets.
1. Database from which the final values is looked from (quot;NetDataquot;)
- Dec 18 Mon 2006 20:34
counting
- Dec 18 Mon 2006 20:34
excel chart and data don't match, help
I have a large spreadsheet and when I try to plot columns in a scatter plot I
don't get what is in the columns. For example this is what you get when you
- Dec 18 Mon 2006 20:34
Access to Excel problem?
Hi all!
- Dec 18 Mon 2006 20:34
MROUND on a negative number.
I came up with the following formula all by myself !!
=IF($I$2=quot;NOT TRANSFERREDquot;,$K$21 $K$22,MROUND($K$21 $K$22-$K$23-$K$24,0.25))
- Dec 18 Mon 2006 20:34
DIFFERENT NAMED CELLS IN COLUMN,HOW DO I GET LAST ONE ON BOTTOM?
i have a column with lots of different informatio in them ranging from dates,
but I want the last cell to be at the bottom and have it update automatically
- Dec 18 Mon 2006 20:34
how do you do co-integration chart
I was wondering if anyone could help me out with cointegration charts in Excel.
Thanks in advance.Hi,
- Dec 18 Mon 2006 20:34
How do I create a required password before opening an excel doc?
I am trying to protect my excel spread sheet doc, where it will require to
enter a password prior to opening the document, each time someone wants to