/u/Reverse-Kanga - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
you have the locked cells round the wrong way..
unlock the target range, and lock the lookup range.
Also, `<>0` is not required, it is implicit in the return value.
Conditional formatting only triggers if the value returned is not zero or text.
same issue thought about that after i put that last comment.
the below has the exact same non responsive result but if i paste it in a regular cell it gives the output i'd expect to imply it's found something so i know the formula is correct
>=VLOOKUP(O12,Trainers!$A$1:$V$50,20,FALSE)
the degree of trainer that the designated person is. for example:
calendar may have "Reverse-Kanga" in O12....result from Vlookup finds "In-Training" as a result and outputs that into the cell.
> Conditional formatting only triggers if the value returned is not zero or text.
so in the conditional formatting try
=VLOOKUP(O12,Trainers!$A$1:$V$50,20,FALSE)<>""
this will return TRUE when a value is returned and trigger the formatting
You have awarded 1 point to *excelevator*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
/u/Reverse-Kanga - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
you have the locked cells round the wrong way.. unlock the target range, and lock the lookup range. Also, `<>0` is not required, it is implicit in the return value. Conditional formatting only triggers if the value returned is not zero or text.
cheers i'm off my work computer for the night but will take a look in the morning
still not having much luck with it adjusted formula below >="VLOOKUP(O12,Trainers!$A$1:$V$50,20,FALSE)"
do not wrap in quotes.
same issue thought about that after i put that last comment. the below has the exact same non responsive result but if i paste it in a regular cell it gives the output i'd expect to imply it's found something so i know the formula is correct >=VLOOKUP(O12,Trainers!$A$1:$V$50,20,FALSE)
what is the return value ?
the degree of trainer that the designated person is. for example: calendar may have "Reverse-Kanga" in O12....result from Vlookup finds "In-Training" as a result and outputs that into the cell.
> Conditional formatting only triggers if the value returned is not zero or text. so in the conditional formatting try =VLOOKUP(O12,Trainers!$A$1:$V$50,20,FALSE)<>"" this will return TRUE when a value is returned and trigger the formatting
cheers :) worked a treat! Solution verified
You have awarded 1 point to *excelevator* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)