Re: Help needed with priority level
From: Dave D-C (dacromley_at_wyoming.kom)
Date: 01/23/05
- Next message: Trevor Shuttleworth: "Re: Font to change color automatically based on value in cell."
- Previous message: Bob Phillips: "Re: Relative Addresses in equations"
- In reply to: _SPCA: "Help needed with priority level"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 Jan 2005 11:27:18 -0800
It seems pretty straightforward to, on the sheet,
1) sort the colors by priority
2) the New List would be
=IF(B3 > 0, A3, "") [this copied down]
Or, if you want to save the old Color list, copy it
and the priorities to other columns and sort there.
Are you wanting the code to do this?
>I have been able to do this with cascaded IF statements, but ..
I'd like to see one of your IF statements.
_SPCA wrote:
>I need to take this list and pick a color by means of priority. In
>this example, I put a priority of 1 for the color of orange in the
>cell next to the color, a priority of 2 for the color gray, and a
>priority of 3 for the color red. I need the New List to reflect the
>priority that I have chosen. Sometimes I may choose only 2 levels,
>sometimes 4.
>
>I have been able to do this with cascaded IF statements, but managing
>lists of 30 or more colors can be cumbersome. In addition to this, I
>am managing 20 separate lists of colors.
>
>Color Priority New List
>
>red 3 orange
>blue gray
>green red
>black
>white
>orange 1
>cyan
>magenta
>gray 2
>purple
>
>
>Not sure if this should have been in the programming group or function
>group. Sorry for the crosspost.
- Next message: Trevor Shuttleworth: "Re: Font to change color automatically based on value in cell."
- Previous message: Bob Phillips: "Re: Relative Addresses in equations"
- In reply to: _SPCA: "Help needed with priority level"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|