Hi Guys,
Firstly I'm really sorry if this question has already been asked, i did have a really good rummage and couldn't find anything.
i have a column that I enter a code in (lets say E4), which is the one i want to conditional format.
I want this to be linked to a different cell that COULD have the word "keighley" in it (B1). IF the word "keighley" is in this cell i want this to trigger a list of acceptable codes (on a different sheet) and the the cell I enter the code in (E4) to highlight if not on the list...
Is this even possible?
Could anyone help me please?
Thank you
Firstly I'm really sorry if this question has already been asked, i did have a really good rummage and couldn't find anything.
i have a column that I enter a code in (lets say E4), which is the one i want to conditional format.
I want this to be linked to a different cell that COULD have the word "keighley" in it (B1). IF the word "keighley" is in this cell i want this to trigger a list of acceptable codes (on a different sheet) and the the cell I enter the code in (E4) to highlight if not on the list...
Is this even possible?
Could anyone help me please?
Thank you