I have a block of cells A1:D4. I want to set the fill color of that block based on the value of cell F1, which should have the form #XXXXXX, where “X” is a hexadecimal digit. And as I change the values of cell F1 the fill colors change as well. Is this possible? I tried conditional formatting rules but it looks like I can only set the fill color to a single static value.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting to change the Fill color of a cell based on the hex value of a different cell.
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Conditional formating should be able to do this, or something like it.
The fact that F1 contains hexadecimal digits is, I think, irrelevant, Excel will just use the underlying value, regardless of how it's formatted.
But I think you might have to set up a new CF rule for each different colour that you want, and that could be fiddly, IF you want lots of colours.
The fact that F1 contains hexadecimal digits is, I think, irrelevant, Excel will just use the underlying value, regardless of how it's formatted.
But I think you might have to set up a new CF rule for each different colour that you want, and that could be fiddly, IF you want lots of colours.
Last edited:
Upvote
0
Errrr... yeah that’s not ideal.
How about this, then: I set the fill color of F1 through the Font menu, then I click a button that executes a VBA macro that will set the Fill color of cells A1:D4. That might be a better solution anyway.
How about this, then: I set the fill color of F1 through the Font menu, then I click a button that executes a VBA macro that will set the Fill color of cells A1:D4. That might be a better solution anyway.
Upvote
0
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Yep, I guess you could do that.
Need help ?
Need help ?
Upvote
0
Similar threads
- Solved
