+ Reply to Thread
Results 1 to 2 of 2

How to Utilize a formula to check for a cell's color

  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Philadelphia,PA
    MS-Off Ver
    2013
    Posts
    31

    How to Utilize a formula to check for a cell's color

    Is it possible to have a formula that looks at what color a cell is and if it is a color, lets say "blue", then it will take the value in that cell and input that value into a different cell in another location?

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to Utilize a formula to check for a cell's color

    No, if there is a rationale for the blue color, you could look at that, but formula's don't see colors. You would need to use VBA
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check boxes that delete other check boxes and change the color of another cell.
    By nhamhamilton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2014, 02:40 PM
  2. Replies: 1
    Last Post: 06-23-2014, 05:06 PM
  3. Would like to utilize text-to-speech when a cell increases or decreases in value
    By swedum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 04:56 AM
  4. Replies: 1
    Last Post: 06-26-2011, 07:39 PM
  5. Check and color a cell if ... (VBA)
    By cambridge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2010, 04:20 PM
  6. Custom header - utilize a cell for it's contents
    By SHIPP in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2005, 11:35 AM
  7. ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS?
    By datachall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2005, 06:06 AM

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