conditional formatting in attached file not working in excel 2007

Hi Experts

I cannot get the trending arrows to show in excel 2007...the attached example is excel 2003...my table (see tab 5 attachment) goes across in my workbook, as opposed to downwards as per tab 5.
learn-conditional-formatting-exc.xls
route217JuniorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FlysterCommented:
I have Excel 2007 and the formatting seems to be working. Are you not seeing the arrows? Could you provide your 2007 workbook?

Flyster
route217JuniorAuthor Commented:
Hi expert

yes not seeing the arrows and...cannot up load due to restriction. ..sorry.
Harry LeeCommented:
route217,

If you don't see the arrows in Excel 2007, your problem is absolutely not conditional formatting, since the trending arrows are shown using In Formula Concatenate by using &.

All your conditional format do in Tab 5 is to give the text color Red, Blue, or Black.

I'm opening your file with Excel 2003, 2007, 2010, and 2013, and I don't have any problem seeing the Arrows.

Can you explain your problem a little more?
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

route217JuniorAuthor Commented:
Hi experts

I have tried to recreate the trending  arrows using new worksheet (lets ignore the one I uploaded) this is where I cannot see the trending arrows...when i open the attachment its fine. ...the problem is when I try to recreate in a new worksheet....

and apologies if the question was poorly worded.
FlysterCommented:
See attached file. It uses the same formula as the one you provided, I just modified the cell reference:

=ROUND(A2,0) & " " &  IF(A1<A2,"¿", IF(A1=A2,"¿","¿"))

The first part, =ROUND(A2,0) , just rounds the number in the reference cell. The second part,
 IF(A1<A2,"¿", IF(A1=A2,"¿","¿")), is an IF Statement that selects which symbol to show. The symbols appear through the formula, not conditional formatting. The formatting comes with the font color being changed depending on the cell value change.
TrendingArrows.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Harry LeeCommented:
Route217,

As Flyster says, it's about the formula that you have issue with.

You have to first understand the formula.

Please be aware that EE is not supporting the Triangle shapes and Round Dot. I have turn them into text so that you don't see the ¿ like in Flyster's post.
The & inside the formula is to help you combining the results of multiple section of a formula, and convert the whole result into a Text String.

In your formula, =ROUND(B5,0) & " " &  IF(B4<B5,"Up Pointing Triangle", IF(B4=B5,"Round Dot","Down Pointing Triangle")), the sections are
=ROUND(B5,0)
&
" "
&
IF(B4<B5,"Up Pointing Triangle", IF(B4=B5,"Round Dot","Down Pointing Triangle"))

While B5 = 549, the first section =Round(B5,0) will return 549. The second section will return " ", A Space.
Then the third section will compare B4 and B5. If B4 is smaller then B5, it will return a Up Pointing Triangle. If B4 = B5, it will return a Round Dot. Finally if B4 is not smaller than B5, and B4 is not equal to B5 (Which means B4 is lager than B5, then it will return a Down Pointing Triangle.

In your sample, B4 is 566, and B5 is 549, means B4 is larger then B5. The 3rd section will return a Down Pointing Triangle.

Combining the result of the 3 sections it will give you "549" & " " & "Down Pointing Triangle".

Combining the use of conditional formatting. If B4 is larger than B5, it will turn the text into Red, It will give you a Red Color result of 549 Down Point Triangle.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.