Thread: Changing a cell if its value is not as great as another
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gupta A. Gupta A. is offline
external usenet poster
  
Posts: 7
Default Changing a cell if its value is not as great as another
Say i have two cells, A1 is dynamic. In A2 i want the maximum value whic
hever appears in A1. For example if A1 becomes 10, and then drops to 5, i
want A2 to display 10 until the value becomes greater than ten.
Reply With QuoteReply With Quote