Results 1 to 10 of 10

Can Excel autoformatting choose the fill color automatically when I enter data in a cell?

Threaded View

Calab Can Excel autoformatting... 09-01-2024, 10:00 AM
AliGW Re: Can Excel autoformatting... 09-01-2024, 10:11 AM
AliGW Re: Can Excel autoformatting... 09-01-2024, 10:12 AM
Calab Re: Can Excel autoformatting... 09-01-2024, 10:13 AM
AliGW Re: Can Excel autoformatting... 09-01-2024, 10:20 AM
JohnTopley Re: Can Excel autoformatting... 09-01-2024, 10:57 AM
AliGW Re: Can Excel autoformatting... 09-01-2024, 11:07 AM
Calab Re: Can Excel autoformatting... 09-01-2024, 03:51 PM
JohnTopley Re: Can Excel autoformatting... 09-01-2024, 11:22 AM
ByteMarks Re: Can Excel autoformatting... 09-02-2024, 07:10 AM
  1. #1
    Registered User
    Join Date
    10-31-2011
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 2003 (v11.0) and newer
    Posts
    10

    Question Can Excel autoformatting choose the fill color automatically when I enter data in a cell?

    I have a small sheet with a fair number of lines on it. When I enter a name in the first column, I would like that row to automatically fill the background color. If I entered a name that was already there, I would want to see the same color used as before. If the name has not been added to the column before, I would want a new color to be picked.

    Untitled 1.xls

    I know I can use conditional formatting, but entering a new format every time I entered a new name will get tedious quickly.

    Maybe I could use a formula to sum all the ascii values of the letters in a name and use that for the color number?

    Is this possible?
    Last edited by Calab; 09-01-2024 at 10:21 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically fill some data in a textbox when I choose an option from the combo box
    By aayush_1231 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-27-2019, 03:10 AM
  2. How to automatically sum based upon interior fill color when the fill color changes
    By Murman01 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-10-2017, 10:41 AM
  3. Automatically Fill in Formula as you enter data
    By leftrightleft in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2014, 05:54 PM
  4. Replies: 3
    Last Post: 07-08-2010, 06:48 PM
  5. Can I custom choose my fill color?
    By excelmaster5000 in forum Excel General
    Replies: 3
    Last Post: 05-11-2008, 02:21 PM
  6. [SOLVED] can excel automatically enter the date data in a cell was entered
    By mg_sv_r in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2006, 06:30 AM
  7. [SOLVED] Cell Fill Color:automatically
    By Scott Cadreau in forum Excel General
    Replies: 1
    Last Post: 12-22-2005, 01:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1