Le 4 mai 2021, la plateforme Yahoo Questions/Réponses fermera. Elle est désormais accessible en mode lecture seule. Aucune modification ne sera apportée aux autres sites ou services Yahoo, ni à votre compte Yahoo. Vous trouverez plus d’informations sur l'arrêt de Yahoo Questions/Réponses et sur le téléchargement de vos données sur cette page d'aide.

Can MS Excel change a cell based on the format of another cell?

I want to set the value of one cell based on the background color of another cell. The value should change it the background color changes. Is this possible? How is it done?

Mise à jour:

I know you can use conditional formating to change the format of a cell based on the VALUE of another cell, or ANY expression. I want to know if you base the conditional formating on the FORMAT of another cell.

Mise à jour 2:

So far Sara M is leading for Best Answer. I still need time to actually test to be sure this works.

8 réponses

Pertinence
  • il y a 1 décennie
    Réponse favorite

    To do this you need to create a User Defined Function (UDF). This is easier to do than it sounds. First, open the VBA window:

    >ALT+F11 (Or go to: Tools> Macro >Visual Basic Editor)

    Go to: >Insert >Module

    >Paste in the function. I found one that works called "CellColor" from www.ozgrid.com

    >Exit the editor

    To use this particular UDF to check cell A1, just type:

    = CellColor (A1)

    for a number result representing the cell color

    or

    =CellColor (A1, TRUE)

    for a text color name result

  • il y a 6 ans

    This Site Might Help You.

    RE:

    Can MS Excel change a cell based on the format of another cell?

    I want to set the value of one cell based on the background color of another cell. The value should change it the background color changes. Is this possible? How is it done?

    Source(s) : ms excel change cell based format cell: https://tr.im/SpEfp
  • il y a 6 ans

    I don't know why I am even helping you since you are such a dick but find an icon on your excel that looks like a brush. select the original cell which you want to copy as a style for your other cell. Once your curser is on that one cell that you like hit that brush icon and immidiately after that hit the cell which you want to look like your "original" cell where you had first clicked before clicking on the brush icon and it should do the trick. But why would someone like you bother with excel? YOu know there is a better application for people like you, it is called MS Word or I know an even better application which should make your complicated life even better it is called notepad. I know people like you use Windows operating systen and that app comes free with it. Now I know I sound like a dick but maybe I do not for you since thats the kind of answer you gave me and I have a simple question for you man. Why dont you answer the question itself why go extra mile and be a dick? is there any particular reason for you to dop that? I mean do be a dick?

  • Anonyme
    il y a 5 ans

    Reverse Phone Number Look Up Services

  • il y a 6 ans

    Use the format painter feature, in the upper left side in the "Home" bar. It's not difficult to figure out.

  • il y a 1 décennie

    It is not based on the value of the cell. You would have to side click on the cell that you want to change the color > format cell > patterns> select color and press okay

  • il y a 1 décennie

    yes.. on several different scopes depending on what you want it to do. everything from simply copying the format of one cell to another to the "if" funcion or "table" function. They all are functions that are based on the format of certain cells.

  • Anonyme
    il y a 7 ans

    You can always use CTL + H

    Thats the best option.

Vous avez d’autres questions ? Pour obtenir des réponses, posez vos questions dès maintenant.