You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Conditional formatting icons help

Conditional formatting icons help

Price: FREE

I am trying to make a visual skills matrix spreadsheet. I have formatted the cells to display the 5 graduated black and white icons that show from an empty circle to a filled in circle. These are set from 0 experience, to 100 experience(using numbers as opposed to percent). This works fine. What I need is a way to get a green filled in circle displayed for those people that can train, so basically have more than "100". I can enter anything for this to happen, but cannot figure out how to do this. Does anyone have a solution for me? I can provide more information if this is not clear enough.

Visit publisher's web-site: Conditional formatting icons help

Category and Tags: ExcelTutorials :

Related Tutorials

Changing icons in conditional formatting

Free: Yes
Tags: Excel ›

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?

Can I put icons to the right side of numbers when using conditional formatting?

Free: Yes
Tags: Excel ›

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"?

How customize color conditional format icons?

Free: Yes
Tags: Excel ›

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.

Conditional formating

Free: Yes
Tags: Excel ›

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.

Conditional Formatting

Free: Yes
Tags: Excel ›

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 icons

Free: No
Tags: Flash › Excel Logos and Icons

Glass web icons. Easy change colors and size.

Flash Icons

Free: No
Tags: Flash › Excel Logos and Icons

Flash icons made for use in projects for websites, documents, and creative designs.

16 Web Icons

Free: No
Tags: Flash › Excel Logos and Icons

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.

Animated Icons with Rollover Effects

Another set of icons made in flash and animated with roll-over effects. Go and grab your copy today!

Interactivity icons

Free: No
Tags: Flash › Excel Logos and Icons

Interactivity Icons V.2 And Cool Design
1 Adobe Flash Cs3 File
2 Actionscript 2.0
3 Resizable icon
4 So Easy To Add, Drag And Drop
5 Easy To Change Color

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing