Thread: Placing Icons
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
  
Posts: 99
Default Placing Icons
Hi,

I made a small change to the formula:

=IF(ABS(A2)<ABS(B2),1,=IF(ABS(A2)ABS(B2),3,2))

This will show a yellow arrow when Previous and Current have the same
value.

Wouter.
Reply With QuoteReply With Quote