We help IT Professionals succeed at work.

conditional formatting in attached file not working in excel 2007

route217
route217 asked
on
287 Views
Last Modified: 2014-01-07
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
Comment
Watch Question

CERTIFIED EXPERT

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

Flyster
route217Junior

Author

Commented:
Hi expert

yes not seeing the arrows and...cannot up load due to restriction. ..sorry.
CERTIFIED EXPERT
Top Expert 2013

Commented:
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?
route217Junior

Author

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.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.