Show Comments on Criteria

Originally Posted by ChemistB

If you want the warning comment to show up when the user enters a value in column B, you could use Data Validation to do this. (See attachment)

Select your range (i.e C3:C12) > Data Validation> Custom
=C3=B3
Go to "Error Alert" tab, Information (you could use Warning also)
Enter your text.
Does that work for you?

I still dont think thats what Im trying to do, but thanks for the tip.