Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Cell Colors

I would like to create a feature within Excel where I type in a "word" and
when I do, the cell I am will automatically color fill with the text in the
cell when I press enter.

I realize you can record a macro to do this, but I have over 100 words that
need color back filled and you can only save 52 macros. I thought of "2
digit" shortcuts but with macro help I don't find where I can save except for
the standard "1 digit" shortcut.

I thought of conditional formatting but I am unfamiliar with that step and
it appears that I would only be allowed up to 3 words with this.

Can someone explain to me how it is I could do this? It is for a
spreadsheet where the "words" are actually Company/Property names that have
specific meaning when colored that is different from the other information in
the spreadsheet.

If it is with conditional formatting, then could I create a list of words
and use the same color?

I thought of VBE, but I am unfamiliar with coding in it.

All assistance will be much appreciated.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell References [email protected] Excel Discussion (Misc queries) 2 November 15th 06 11:37 PM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
cell border colors in Excel Rob Excel Discussion (Misc queries) 9 April 25th 06 01:44 AM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"