I've been trying all afternoon to get this done and I searched numerous ways to do it on the forum.
I have numerous sheets which I use as Lookups. Of which, certain rows have different styles applied to them (this is so that I avoid having to create extra, repeated columns in each sheet).
Then I have a sheet which will use the data in other sheets as drop-downs - this part is straight-forward. However, I would like it that whenever i select an option, if the associated row in the lookup table/sheet has formatting, the formatting will be applied to the cell where the drop-down is in.
I have created styles for each type of formatting, and to my knowledge, applied them to each row/cells respectively. Styles include changes to font color, family, size, alignment and wrap-text.
To bring this together, I have done Conditional Formatting, using Formula is, with the formula;
Code: Select all
STYLE(VLOOKUP(B2; $Heads.$A$2:$B$16; 2; 0))
- B2 is the drop-down cell,
- the cells inside the Heads sheet is the data-table,
- the 2nd column is the where I want to read the style from.
- I notice no styles listed in the Applied Styles menu (F11 -> Applied Styles) after having repeatedly selected cells and double-clicked the style to apply (even used Fill, but no effect).
- Selecting cells to have Default Formatting does nothing.
If I may be so bold, What's the issue? Can anyone shed some light on what I'm doing wrong?
Things that helped me in my research;
- VLOOKUP tutorial helping me understand parameters in VLOOKUP viewtopic.php?f=75&t=46746
- A sample document from a thread that is lost to me right now but showed me it's possible - I have provided it as reference.
- FJCC explaining STYLE() looks for existing styles applied to cells viewtopic.php?f=9&t=100581&p=484157&hil ... up#p484166