I need a message to display if a cell is a certain value.

I.e. if any cell's in a range (d35 through z35) = "PD" then message in Cell (what ever cell has PD) = "text"

I know about conditional formatting but this doesn't help me. I also would like to avoid using an IF function becasue I am already using that to get the "PD" into the cell.

I think I can do this using VBAor a macro but I know nothing about this. Any help - detailed - think 1st grade - would be greatly appreciated. Thanks in advance.