Can Excel create a conditional Comment on a cell?
On Feb 16, 10:05 am, Desmond
wrote:
Can Excel create a conditional Comment on a cell? i.e. if cell value is above
a value, create a comment ("Value is Very High = 'Cell Value' ")
Yes- use IF function
Example
Column A put 1,2,3,4,5 A1:A5
Column B IF (A12, "too high", "too low")
copy B1 to B1:B5
|