var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: need to have comment appear if cell = value
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.