Hi MWH,

Lets pretend the cell that contains "SUM(daily_Totals!F6)" is B1,I want it
to look at A1 to compare the values for the up/down arrows

With the value =SUM(daily_Totals!F6) in B1, to display an arrow in C1 which
represents the comparison of the A1 and B1 values, in C1 enter the formula

=IF(A1=A2,"",IF(A2A1, "p","q")

Format relevant column C cells with the Windings3 font (to show an up or
down arrow); Apply conditional formatting to the relevant column c cells to
color down arrows green and up arrows red.

Now, given your explanation, I would be quie happy with this answer ... were
it not that this was my exact response four posts ago!

I fear that I am missing something!


---
Regards,
Norman



"MWH" wrote in message
...
SUM(daily_Totals!F6) is just cell F6 on worksheet "daily_Totals" The
values on worksheet "daily_totals" comes from an access export query. Lets
pretend the cell that contains "SUM(daily_Totals!F6)" is B1,I want it to
look at A1 to compare the values for the up/down arrows. Am I as clear as
mud! :)



"Norman Jones" wrote in message
...
Hi MWH,

Forgive any obtuseness on my part, but could you explain what values are
held in E8 and F8 (using your cell references) and what the relationship
of these cells is to the SUM(daily_Totals!F6) value. More particularly,
what does the value SUM(daily_Totals!F6) have to exceed for the up arrow
and what does it have to be less than for the down arrow to show?


---
Regards,
Norman



"MWH" wrote in message
...
My initial value is coming from another worksheet within the workbook
=SUM(daily_Totals!F6). The cell adjacent to contains your formula for
showing the arrows =IF(F8=E8,"",IF(F8E8,"p","q") I would like to
combine the formula so the cell that contains the value and will show
the arrow also.




"Norman Jones" wrote in message
...
Hi MWH,

Ok, Just one more question :) is there a way to concatenate this
formula?=SUM(daily_Totals!F6) and your formula
=IF(F8=E8,"",IF(F8E8,"p","q")


It is not apparent what you mean by 'concatenate' in this context.

Certainly it is possible to replace one or more of the above cell
references with an expressions which return values. For example:

= If(SUM(daily_Totals!F6) Some_Value, "p","q")

You would, however, need to provide details sufficient for someone to
construct an appropriate formula.

More particularly, in your initial post you clearly enunciated the
A1A2 and A1<2 conditions..

If you can provide similar information for the SUM(daily_Totals!F6)
expression, I am sure that solutions will be forthcoming.

---
Regards,
Norman



"MWH" wrote in message
...
Hi Norman

Ok, Just one more question :) is there a way to concatenate this
formula?=SUM(daily_Totals!F6) and your formula
=IF(F8=E8,"",IF(F8E8,"p","q")
I'm getting the data from another worksheet, and I would
like
the up-arrow or down-arrow to show next to the value. I am trying to
develop
an indicator to track man-hours and show where are our overall gains
or
losses are coming from. The original data is coming from access and
exported
to excel. Thanks again!

"Norman Jones" wrote in message
...
Hi Ernestgoh,

I know this off topic but I read with interest on conditional
formatting. How do you go abouts setting the condtion? I went to
Edit-Go To-Special.


:Debra Dalgleish has a superb tutorial on conditional formatting
(one of a number!) at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"ernestgoh"
wrote in message
...