View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jIM jIM is offline
external usenet poster
 
Posts: 17
Default 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