Thread: Format and DDE.......Bet this can't be done
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Format and DDE.......Bet this can't be done
Use two cells rather than one.


Store the original value of A1 in A2 and then allow A1 to update
periodically via DDE. Use Conditional Formatting on A1 to test is it is
greater or less than A2.
--
Gary''s Student - gsnu200719

Reply With QuoteReply With Quote