LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default Conditional Formatting - colored arrow showing positive trend

I wanted to draw attention to positve and negative trends through the use of
color. I used conditional formatting for the number ... but also wanted a
corresponding graphic.

I created the following Iif statement:
=IF(P100,$U$2,$V$2) ... note P10 is the number being evaluated.

I placed a green up arrow in U2 and a red down arrow in V2 to show a
positive or negative; however, I really would like the arrows to change color
also.

Because the arrow is an "object" it is neither positive nor negative;
therefore, I can't change it's color. Any recommendations?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I evaluate whether a trend is positive or negative? leotoni Excel Worksheet Functions 7 April 3rd 23 04:26 PM
Editing conditional formatting formula, arrow keys insert range. Bob Arnett Excel Discussion (Misc queries) 3 May 20th 09 12:56 AM
Conditional formatting: colored bar with pointer on current status Hannes Excel Discussion (Misc queries) 0 November 20th 07 08:50 AM
Shaded or Colored cells not showing up macmiester Setting up and Configuration of Excel 2 October 25th 07 03:27 AM
When I select a colored font, text is still showing up black. Why? onemanhattanrebel Excel Discussion (Misc queries) 1 September 25th 05 02:23 PM


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"