+ Reply to Thread
Results 1 to 4 of 4

Cell value based on another cell color

  1. #1
    Registered User
    Join Date
    06-26-2018
    Location
    USA
    MS-Off Ver
    2017
    Posts
    9

    Cell value based on another cell color

    Is there a formula what would automatically enter static number based on another cell color?

    For example

    if cell F9 is green then cell G9 will be always 12345678
    if cell F10 is green then cell G10 will always be 12345678


    Thanks

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Cell value based on another cell color

    Are the cells colored manually, through VBA, through conditional formatting?

  3. #3
    Registered User
    Join Date
    06-26-2018
    Location
    USA
    MS-Off Ver
    2017
    Posts
    9

    Re: Cell value based on another cell color

    Quote Originally Posted by Pepe Le Mokko View Post
    Are the cells colored manually, through VBA, through conditional formatting?
    Through conditional formatting. I can do recommendation. or something easy like if cell G9 contain any value then G10 will always be 12345678.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Cell value based on another cell color

    What are the conditions inside "conditional formatting", see how is it possible to reused them in a formula.
    - Battle without fear gives no glory - Just try

+ 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. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  2. Color Cell Based on Specific Text in Other Cell and Sorting Based on Results
    By kre30a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2016, 07:51 PM
  3. Replies: 1
    Last Post: 12-17-2015, 07:03 AM
  4. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  5. [SOLVED] Color-format a cell which contains data in a column based on the color of another cell
    By Nit3hawK in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2013, 05:25 PM
  6. Delete row based on cell FORMAT (color, font, etc) (not based on cell value)
    By trobey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2012, 10:39 AM
  7. Replies: 5
    Last Post: 05-10-2012, 10:49 PM

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