Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I evaluate whether a trend is positive or negative? | Excel Worksheet Functions | |||
Editing conditional formatting formula, arrow keys insert range. | Excel Discussion (Misc queries) | |||
Conditional formatting: colored bar with pointer on current status | Excel Discussion (Misc queries) | |||
Shaded or Colored cells not showing up | Setting up and Configuration of Excel | |||
When I select a colored font, text is still showing up black. Why? | Excel Discussion (Misc queries) |