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

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

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?

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?

Reverse Phone Number Look Up Services

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

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

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.

You can always use CTL + H

Thats the best option.