Yahoo 知識+ 將於 2021 年 5 月 4 日 (美國東岸時間) 停止服務,而 Yahoo 知識+ 網站現已轉為僅限瀏覽模式。其他 Yahoo 資產或服務,或你的 Yahoo 帳戶將不會有任何變更。你可以在此服務中心網頁進一步了解 Yahoo 知識+ 停止服務的事宜,以及了解如何下載你的資料。

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?

更新:

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.

更新 2:

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

8 個解答

相關度
  • 1 十年前
    最愛解答

    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

  • 6 年前

    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?

    資料來源: ms excel change cell based format cell: https://tr.im/SpEfp
  • 6 年前

    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?

  • 匿名
    5 年前

    Reverse Phone Number Look Up Services

    資料來源: https://tinyurl.im/aHJHc
  • 6 年前

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

  • 1 十年前

    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

  • 1 十年前

    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.

  • 匿名
    7 年前

    You can always use CTL + H

    Thats the best option.

還有問題嗎?立即提問即可得到解答。