caroline wright
New Member
- Joined
- Oct 17, 2013
- Messages
- 2
Hi, I hope somebody might be able to give me some tips / proper help on how to set the cell colour by using cell values for hue, saturation and brightness.
Essentially I am trying to find a way to make colour charts to use when paint matching in object conservation (think really finely differentiated dulux colour charts, but in a grid), so that I can note the colour of a pigmented fill as I mix it, then again once it dries and after applying different varnish coats, so that after testing enough combinations I can find where I need to start in order to get the right colour when I'm finished. (so it doesn't matter if the absolute colour values aren't actually correct once they come out of the printer - as long as I keep using the same sheet then its all relative).
Obviously I can just make a table in any windows programme, and go through and manually set each cell, so each row is a different hue value (probably only +1 on the previous), and each collumn is a particular level of saturation, (probably -1 on the preceding). but this is extremely tedious. and as the values seem to alter ever time I open up the colour control, I can't even see how I would record a macro. Besides, next week I'll want a different set of values, probably at different intervals, and whilst I don't mind putting the hours in, not if its going to be the same hassle every time.
What I would really like is a simple formula so that for any particular cell in the table: column A determines respective hue, and row 1 determines its level of saturation, (with another fixed cell somewhere determining level of brightness) - going to have to keep it to just 2 variables for now! then I can just fill the relevant series to set the range of hues and saturation I need.
Once that is sorted, I'll start worrying about inputting starting and finishing values, size of interval and swapping in brightness values. But for now would just love to know how to sort the fill colour.
Essentially no experience with VBA, much more a formula data manipulation, dynamic range and a pivot table kind of a girl, but I use to record the odd macro and tweak the resulting code. Its been a while, but I am fairly capable when determined.
Genuinely first question ever posted in a forum, but I used to use quite a lot to search for other answers, hopefully I haven't missed an obvious existing solution. and massive thank you for any help you might be able to offer. Caroline
Essentially I am trying to find a way to make colour charts to use when paint matching in object conservation (think really finely differentiated dulux colour charts, but in a grid), so that I can note the colour of a pigmented fill as I mix it, then again once it dries and after applying different varnish coats, so that after testing enough combinations I can find where I need to start in order to get the right colour when I'm finished. (so it doesn't matter if the absolute colour values aren't actually correct once they come out of the printer - as long as I keep using the same sheet then its all relative).
Obviously I can just make a table in any windows programme, and go through and manually set each cell, so each row is a different hue value (probably only +1 on the previous), and each collumn is a particular level of saturation, (probably -1 on the preceding). but this is extremely tedious. and as the values seem to alter ever time I open up the colour control, I can't even see how I would record a macro. Besides, next week I'll want a different set of values, probably at different intervals, and whilst I don't mind putting the hours in, not if its going to be the same hassle every time.
What I would really like is a simple formula so that for any particular cell in the table: column A determines respective hue, and row 1 determines its level of saturation, (with another fixed cell somewhere determining level of brightness) - going to have to keep it to just 2 variables for now! then I can just fill the relevant series to set the range of hues and saturation I need.
Once that is sorted, I'll start worrying about inputting starting and finishing values, size of interval and swapping in brightness values. But for now would just love to know how to sort the fill colour.
Essentially no experience with VBA, much more a formula data manipulation, dynamic range and a pivot table kind of a girl, but I use to record the odd macro and tweak the resulting code. Its been a while, but I am fairly capable when determined.
Genuinely first question ever posted in a forum, but I used to use quite a lot to search for other answers, hopefully I haven't missed an obvious existing solution. and massive thank you for any help you might be able to offer. Caroline
