View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default Totally stuck trying to format,loop etc...please help a novice

On 22 Iul, 20:26, ytayta555 wrote:

Something in your Step 1 is not logical , if the value is
< or = , or , or = , in the case the value is
equal ,
you always shall have the color red or green ( not shure ) .
Maybe you must put one more condition , such as , if value is
equal to the value at time minus 4 cells earlier , then ,
value to be "x" and color ... how you want .