Hi,
I'm hoping this is possible (and relatively easy) but couldn't find any examples on Google.
I want to use the format cells containing specific text conditional formatting rule, but instead of typing a specific word/text I want it to lookup a range of words on another sheet. The range might change later on so it needs to be dynamic.
Can anyone help?
Thanks
Baker
I'm hoping this is possible (and relatively easy) but couldn't find any examples on Google.
I want to use the format cells containing specific text conditional formatting rule, but instead of typing a specific word/text I want it to lookup a range of words on another sheet. The range might change later on so it needs to be dynamic.
Can anyone help?
Thanks
Baker