Change cell color using macro

December 18, 2010 at 02:24:38
Specs: Windows 7
Hi. I’d like to change the cell fill-color on (B cell) once I enter a value of 1 to 5 to (A cell). Each number represents a color. Can you help me find out the MACRO for this? Appreciate your big help.

See More: Change cell color using macro

Report •

December 18, 2010 at 07:55:52
Why do you want to use a macro? Conditional Formatting can do this for you.

Give us more info and we'll see if we can help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question