Hi,
I wondered if there was a way to set conditional formatting on a sheet where the worksheet the formula references changes based upon what the user selects in a list box?
i.e. I want a cell on my front sheet to colour green or red based upon a vlookup result - if the user selects an entry from the list box, I'd like the vlookup formula to reference the worksheet selected in the list box.
I could do it via VBA, but wondered if there was a non-coding way to do it?
Thanks!
I wondered if there was a way to set conditional formatting on a sheet where the worksheet the formula references changes based upon what the user selects in a list box?
i.e. I want a cell on my front sheet to colour green or red based upon a vlookup result - if the user selects an entry from the list box, I'd like the vlookup formula to reference the worksheet selected in the list box.
I could do it via VBA, but wondered if there was a non-coding way to do it?
Thanks!
Last edited: