Home |
Search |
Today's Posts |
#1
|
|||
|
|||
2 cells 2 colors
Hi All, Here's my glitch: I've got 2 dropdown/combo boxes in a user form. Both offer various color options. The 1st one colors an active cell the correct color that is chosen. The 2nd dropdown colors the cell directly to the right or the active cell in the same manner. My code is pretty crude & not very efficient, but it works correctly. The problem is when color 2 is not chosen. Currently, if a color isn't chosen, I can put an "X" in the cell, or color it a certain color, but what I want is to color it whatever the color of the active cell is. Any ideas? Thanks! -- Soundman ------------------------------------------------------------------------ Soundman's Profile: http://www.excelforum.com/member.php...o&userid=24428 View this thread: http://www.excelforum.com/showthread...hreadid=387999 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
linking cells colors | Excel Worksheet Functions | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions |