I am creating a testing tracking sheet. Using conditional formatting. i have the fields set to color based on the entered result of the test. a 'P' wil mark the cell green, an F will mark it red, and so on.
what i am trying to figure out how to do, is if i mark a field with an "F" for failure. i would like a pop up box to appear asking for a bug # , or possibly a hyperlink.
I am a novice with Excel, but can understand complex instructions. can anyone help?