Re: Auto fill color change

Tech-Archive recommends: Fix windows errors by optimizing your registry

I appreciate your quick response!! the only problem I see with this is that
everybody must have it installed in order for it to work. That isn't a
possibility at work because we are not allowed to install any type of
software. Is there another solution?
--
Thanks
Dave


"Norman Jones" wrote:

> Hi Dave,
>
> See the freely downloadable CFPlus addin which is freely downloadable at:
>
> http://www.xldynamic.com/source/xld.CFPlus.Download.html
>
>
>
> ---
> Regards,
> Norman
>
>
>
> "Dave" <Dave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:980CB2CC-0323-4C65-AF01-93A0240DEE35@xxxxxxxxxxxxxxxx
> > Sorry .... I need to expand on this thought. I figured out how to get a
> > cell
> > to change for one variable with conditional formatting, however I have 5
> > possible variables of which I would like different colors for each. Can
> > this
> > be done?
> >
> > So for "V" I get a Dark blue fill, "H" I get another color and "A" I get
> > another color and so on.
> >
> > --
> > Thanks
> > Dave
> >
> >
> > "Dave" wrote:
> >
> >> How do I get a cell to change the color fill automatically when specific
> >> data
> >> is entered into a cell?
> >>
> >> I am trying yo build a calender for the company emeployees to fill out
> >> their
> >> vacation schedules. When they enter "V" into a cell, I would like that
> >> cell
> >> to automatically change to a dark blue fill with white text.
> >>
> >>
> >> --
> >> Thanks
> >> Dave
>
>
>
.

Relevant Pages

  • Re: Auto fill color change
    ... I need to expand on this thought. ... >> How do I get a cell to change the color fill automatically when specific ... >> to automatically change to a dark blue fill with white text. ...
    (microsoft.public.excel.misc)
  • RE: Auto fill color change
    ... I figured out how to get a cell ... to change for one variable with conditional formatting, ... "Dave" wrote: ... > to automatically change to a dark blue fill with white text. ...
    (microsoft.public.excel.misc)
  • Re: Original Sort/Data Entry Order
    ... Regarding this sorting query. ... "Dave Peterson" wrote: ... You can rightclick on the destination cell and choose it from the popup. ... Marie Robinson wrote: ...
    (microsoft.public.excel.misc)
  • Re: W2K SP4 Update Rollup STILL sticks (after all the suggested st
    ... > all that MBSA and MDAC stuff? ... or did you uninstall it each time? ... You shouldn't try to install pre-reqs ... Dave reported that the Belarc Advisor missed some details. ...
    (microsoft.public.windowsupdate)
  • Re: How do I end a table?
    ... Thanks, Dave, that worked perfectly! ... > cell of the table so that's the second last line above. ... .ApplyStyleHeadingRows = True ... >>>> I'm trying to create a series of tables in a VBA macro in Word 2002. ...
    (microsoft.public.word.vba.general)