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?
2008-04-28T19:25:52Z
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.
2008-04-29T16:05:19Z
So far Sara M is leading for Best Answer. I still need time to actually test to be sure this works.
Sarah M2008-04-28T19:42:10Z
Favorite Answer
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
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?
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?