- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Complicated Excel Question - Is this possible?
Posted on 8/21/13 at 3:16 pm to LSURussian
Posted on 8/21/13 at 3:16 pm to LSURussian
quote:
Several times I have wanted to have the results in a cell be different colors based on testing the value in the cell but I've never been able to do it except for a negative result being red and a positive result being black.
You can put endless conditional formats on a given cell... couldn't you just manually set the colors to match whatever value is in the cell by adding rules? You could also use the color scale option in the conditional formatting table
This post was edited on 8/21/13 at 3:25 pm
Posted on 8/21/13 at 3:20 pm to hiltacular
Have you tried the conditional formatting? What issues did you run into?
Have you tried mrexcel.com?
Have you tried mrexcel.com?
Posted on 8/21/13 at 3:31 pm to hiltacular
Easy way:
Link the values from each sheet to the other sheets then use the appropriate color scale conditional formatting. Hide the values linked from the other sheets. Done?
In the conditional formatting dialogue, it appears that conditional formatting is sheet specific, so in order to do this another way, you are going to have to pull everything to the reference sheet.
I kind of agree that this seems easy, but you could be over simplifying your issue.
ETA:
If the values are set, you can also use "Format all cells based on their values" set the lowest value to 1 and highest to 4, pick the colors and paste the formats to all of your C9s.
Link the values from each sheet to the other sheets then use the appropriate color scale conditional formatting. Hide the values linked from the other sheets. Done?
In the conditional formatting dialogue, it appears that conditional formatting is sheet specific, so in order to do this another way, you are going to have to pull everything to the reference sheet.
I kind of agree that this seems easy, but you could be over simplifying your issue.
ETA:
If the values are set, you can also use "Format all cells based on their values" set the lowest value to 1 and highest to 4, pick the colors and paste the formats to all of your C9s.
This post was edited on 8/21/13 at 3:36 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News