View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Fill background color automatically by typing a letter in a cell

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 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.