Conditional formatting icons help
I need to put icons to show when a value is below zero it will show up as red. If it is zero or above it will be green. In using the conditional formatting icon sets there are only sets of 3 icons and I need only 2. I am using the '3 traffic light (untrimmed)' group. I have been able to get around the yellow light not showing up, however one thing I can't seem to do is to make the icons a solid colour red and green rather than being a gradient as they look washed out. Also is it possible to make these icons larger?
I am using icons (trafficking) and conditional formatting. By default the icons are always shown left in the cell. Is there some way I change it so it will not be "Icon - number" in the cell but "number - icon"?
Using conditional formatting icons . three or four lights . need to change colors from traditional red, yellow, green, black . would like to modify the colors for one or more of the icons.
I use Excel 2007, I need some help:
1-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting (changing color of cell, color of border) to C3. 2-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to display words 'greater', 'less' or 'equal' to D3. 3-If the value of cell B3 is greater, less or equal to 0, I want to apply a conditional formatting to set only icons to E3, I mean the three icons which represent 'greater', 'less' or 'equal'. I want to display only icons without values in cell E3.
I have a table of values that I wish to colour code.
If the value is less than 45% the cell is red. Above 45% it is green. That is easy to do and I've done it.
However, I want to make the cell also be red if the value is 0 but stay white if there is no value in the cell. Is this possible?
I'm setting the conditional formats using the toolbar icons and not writing the code manually.
Using MS Office 2010
Related Applications & Scripts
Glass web icons. Easy change colors and size.
Flash icons made for use in projects for websites, documents, and creative designs.
16 Web Icons. Every icon can be tinted in any color, and allso filters can be used. Every icon separated is about 15-20 kb.
Another set of icons made in flash and animated with roll-over effects. Go and grab your copy today!