I want to fill a cell with color if it contains a word that contai
letters that I specify. For example words then end with letter "s".
Wildcard search doesn't seem to work?
What is the formula to use

    CRAIG    KEITH
WEEK       
31-Mar        PET REG
07-Apr    PET REG   

Hi im pretty new to this forum, tho dabbled in a bit of excel before.
Basically i have the following
FName   SName   Install Date
aaa       bbb       12/02/06

Re : Excel Quest of an Array Formula
1. Enter an Excel worksheet ; Update the working range of A1:E30 with a
set of random numbers.
2. Look across row 1 and locate the minimum value(s) amidst A1:E1 ; And

It is possible to create quickly an excell table with borders and shadings
(with rows darkened and lightened alternatively) like it can be done with
Word Tables?

What does the $ mean in the cell reference
--
KH_G
-----------------------------------------------------------------------

Ive created a macro and I would like to send it to another user in order
for him to run it on his proper excel files. Ive sent him the file with
the macro attached, how can he register it to have it available each
time he'll open an Excel File?

I need to have certain cells change color at a specific time.  I enter a
date in a cell, say 30 days from today's date. Starting 10 days from today's
date till tomorrow, I need the cell to change to Yellow. From today & beyond
I need the cell to change to Red. Is this possible? I ...

I am computing the days between dates.  I am using Vlookup() to capture
the appropriate dates in another worksheet.  Basically it is this
(where B2 & C2 are in another sheet):
B2            C2            D2

I have a customer who has extensive reports build in Excel. Many of the
report pull data from other spreadsheets, but ultimates somewhere the data
is manually input. My task is to automate the input of the data.
Is there a way to enter a formula into a cell that goes off to an ...

I have created a number of  headings to choose from depending on what action
or actions I am to take with an item.  I am used to using Access where I can
designate that they are checkmark columns.  Then when I click in that column,
a checkmark magically appears.  I know nothing ...

I have a list of  600 names.  I would like to generate a random number
between 1 and 600 for each person but not have any repeating numbers.  So
far I have used
=rand()*600

I am trying to compare values in two ranges, one from the active
workbook and the other from a different remote workbook. I am using the
Vlookup with the table array field being populated from a range of
concatenated cells. The first one defines the path of the remote

I am trying to calculate the average time between starting 1's. The data has
a date which is every day and a 1 or 0 next to it. When the data goes from 0
to 1 I want to start counting until I find the next 1 that follows a 0. Once
I have all those days between starting 1's I want ...

Hi Dave,
The code you gave me a while back works great fro hiding and unhiding
columns rows etc.  Is there a way to use the same code but change it to
worksheets.  I have a bout 15 worksheets that I would like to unhide in