I viewed the VB code that was suggested to overcome many cond. formating.
BUT
It does not work properally when the conditioned range is based on formula.
I dont mind activating mannually a routine instead.

I have an excel spreadsheet which could contain hundreds of rows with hours,
minutes and seconds.  I need to calculate into hours, minutes seconds the
total duration.  I have completed a SUM and changed the calculation total to
HH:MM:SS to stop the 24 hour roll up, however, my ...

I have a defined NAME(e.g. GROUP1) of a group of Cells in a table. Within
this group of cells, I had defined another NAME (e.g. GROUP_1) for those
blank cells that I gathered. My problem is how to make dynamic changes on
the referred cells of GROUP_1, say if I place value in one ...

I've acquired this formula from the Excel 2002 Formula book by John
Walkenbach but I want to extend it's features by rounding it off.
The formula is as follows:
=DATEDIF(G7,H7,"y") & " years, " & DATEDIF(G7,H7,"ym") & " months, " &

I have excell 2000. I have a column of numbers, some formatted red, and some
formatted green. I do not want to split the fiures/numbers, as they may
change in value/colour format.
I want to sum the red figures and sum the green figures at the end of the

Please advise what's wrong with the code below to remove duplicates from a
list to a listbox in an userform. A warning dialog box stated "variable not
defined" to a word "Item"
Sub RemoveDuplicates1()

ok, guys, i need your help... i have an excel file and i can't find a
function i need...
i have two columns, not adjacent.. the first one let's say that has text
cells...so ,does the second one..those texts are   periodically repeated...

I'm trying to separate GST from a total amount and am wondering if anyone
has a formula that can help me do this.
For example, I have a total of  $901.07 and would like to know how much is
the base amount and how much is the GST.  I've tried to subtract 7% but that

I keep for myself ice hockey stats, on several teams.  I'm have a really hard
time figuring out how to get around the goalie minute numbers.  Example say
Goalie A played 60:00:00, where the sixty is sixty minutes, and the next
number is seconds and then the last is ten of seconds ...

I have given a vlookup formula in A1 which is refering to A1 in sheet2.
Its working fine except when we delete or insert a row. If we delete
row A1, then the formula in A1 is refering to A2 in sheet2 and not A1.
The formula I have given is

I have a spreadsheet which contains a record of item types that an
individual can sign for.  However for each individual the item type is
repeated for each cost centre.
ie

I need to set up a separate or linked spreadsheet from data in one column
from 10 by keyword i.e. under a Food Outlet would appear Burger King, Millies
Burger's, Great American Burger etc all appearing under their name but in the
same list as pizza co's etc, I wish to extract by ...

I have tried this a few times and tried to copy and paste but it still keeps
coming back with #N/A but if I double click in the cell that I am trying to
find it then finds it, hope this makes sense

Sheet1 has a list of unique names in column C and comments in column J.
Sheet2 has some of the same names in a different order. How do I go about
creating a formula on Sheet2 that finds the name on Sheet1 and inserts the
appropriate comment?

I am prepaing a worksheet where I have one column containing employee names,
with each employee name spread across 10 merged cells. The rows of those
merged cells containing information specific to each employee..so what I need
to know is whether there is a way for autofilter to ...