Drop down list to change cell fill color but not contents

**dwilhelm07** · 10-17-2016, 10:21 PM

Hello,

I have a list of prices, real estate prices. I have all available properties with a green fill color and all sold properties with a red fill color. All prices vary. I have a function that takes the sum of all green cells and one that takes the sum of all the red cells.

I want to be able to quickly change a cell from red to green and vice versa. I know that I can go into the color option and select the color, but this will draw confusion for the user if they select a different type of green or red. The cells need to be exactly one of the colors. Therefore, I would love to be able to click the cell and then a red and green box appear and I can select one color or the other.

Thanks,

Dan

**pjwhitfield** · 10-18-2016, 02:41 AM

Im not sure about the method you'd like but how about changing the colour if you double click the cell?

The attached will swap the colour around on the cells in columns 1 and 2 when double clicked. (You just need to amend the 255 (red) and 5287936 (green) to match the colours youre using (and obviously change the target checking to match the area you want in your sheet.

Please Login or Register  to view this content.

**dwilhelm07** · 10-18-2016, 02:51 AM

Please look at the last tabs labeled 1st Floor, 2nd floor, etc...
How do I apply what you are saying to my spreadsheet? Double clicking to change the color would work fine for me. Thank you.

**pjwhitfield** · 10-18-2016, 03:21 AM

I was trying to get this working using Workbook_SheetBeforeDoubleClick for a global solution however I kept hitting some unknown error, until that works you can add the following into each of the Floor sheets. In this version you can double click anywhere in a row to change the status of that row (as long as the row is currently a red or green row)

Please Login or Register  to view this content.

I have assumed in the above that your sheets will always have the same setup of 1st two columns containing the data.

**dwilhelm07** · 10-18-2016, 03:29 AM

I just copy and paste this into the Visual Basic Editor, correct?

**pjwhitfield** · 10-18-2016, 03:31 AM

Apologies, yes, copy and paste it into the relevant Worksheets within the VBA Editor

Drop down list to change cell fill color but not contents

LinkBack

Thread Tools

Rate This Thread

Display

Drop down list to change cell fill color but not contents

Re: Drop down list to change cell fill color but not contents

Re: Drop down list to change cell fill color but not contents

Re: Drop down list to change cell fill color but not contents

Re: Drop down list to change cell fill color but not contents

Re: Drop down list to change cell fill color but not contents

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change a cells fill color. VBA to make another cell the same color and also changes.

Add my own color and fill sets to the default drop down list in conditional formatting.

[SOLVED] Click oval option button to fill/unfill color, also change border color to match fill

Macro to change cell text color based on darkness of cell fill color

[SOLVED] change fill color of a range of cells based on color of a cell?

Conditional format to change text color when the cell is manually given a fill color

Automatically change fill color on certain cells depending on color of specific cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions