I know this is do-able, as I've seen it before. I just don't know how to do
it. What I'm trying to do is create an excel spreadsheet for vacations here
at work, where the cells will automatically fill in with a pre-determined
fill/background color when the text letter "V" (for vacation day) is entered
in the cell. It would also be neat to know if another letter, say "S" (for
planned sick/doctors appointment) would work the same way and the cell change
a different color when an employee entered "S".

All I'm trying to do is to highlight the background fill color of cells
automatically when a specific letter is typed into a cell. Thanks very much
in advance for any help you can give here.

Hi Myke
Go to Format>Conditional Formatting>Condition 1 > Cell Value is > Open
second window and select " equal to " third window type in ="v" then press
> Format and Tab> Patern and select colour .

Press button Add>> a second Condition will appear, do the same but in the
third window type ="s" and >Format with a different colour.
Regards
Cimjet
"Myke" <(E-Mail Removed)> wrote in message
news:56DF90BE-09C1-4900-A3EB-(E-Mail Removed)...
>I know this is do-able, as I've seen it before. I just don't know how to do
> it. What I'm trying to do is create an excel spreadsheet for vacations
> here
> at work, where the cells will automatically fill in with a pre-determined
> fill/background color when the text letter "V" (for vacation day) is
> entered
> in the cell. It would also be neat to know if another letter, say "S" (for
> planned sick/doctors appointment) would work the same way and the cell
> change
> a different color when an employee entered "S".
>
> All I'm trying to do is to highlight the background fill color of cells
> automatically when a specific letter is typed into a cell. Thanks very
> much
> in advance for any help you can give here.

PERFECT! Thank you very much. Hope I can return the favor to someone here on
something....works great!

"David Biddulph" wrote:

> Look up "conditional formatting" in Excel help.
> --
> David Biddulph
>
> "Myke" <(E-Mail Removed)> wrote in message
> news:56DF90BE-09C1-4900-A3EB-(E-Mail Removed)...
> >I know this is do-able, as I've seen it before. I just don't know how to do
> > it. What I'm trying to do is create an excel spreadsheet for vacations
> > here
> > at work, where the cells will automatically fill in with a pre-determined
> > fill/background color when the text letter "V" (for vacation day) is
> > entered
> > in the cell. It would also be neat to know if another letter, say "S" (for
> > planned sick/doctors appointment) would work the same way and the cell
> > change
> > a different color when an employee entered "S".
> >
> > All I'm trying to do is to highlight the background fill color of cells
> > automatically when a specific letter is typed into a cell. Thanks very
> > much
> > in advance for any help you can give here.
>
>
>

Depends upon how many letters you are speaking about.

3 or less would allow you to use Conditional Formatting.

More would require VBA or Excel 2007


Gord Dibben MS Excel MVP

On Mon, 24 Mar 2008 09:26:01 -0700, Myke <(E-Mail Removed)> wrote:

>I know this is do-able, as I've seen it before. I just don't know how to do
>it. What I'm trying to do is create an excel spreadsheet for vacations here
>at work, where the cells will automatically fill in with a pre-determined
>fill/background color when the text letter "V" (for vacation day) is entered
>in the cell. It would also be neat to know if another letter, say "S" (for
>planned sick/doctors appointment) would work the same way and the cell change
>a different color when an employee entered "S".
>
>All I'm trying to do is to highlight the background fill color of cells
>automatically when a specific letter is typed into a cell. Thanks very much
>in advance for any help you can give here.