Is it possible to get more than the 4 traffic lights on the conditional formatting rules.
I have 6 conditions I would like to be met and have an icon/traffic light for each but the best I can do is the 4 icons?
Is there any way of increasing the conditions and icons or creating my own bespoke list etc?
Couldnt you use wingdings font or similar (look for black circle perhaps) and use Condtional Formatting with formulas to display different coloured circles?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
See attached workbook
This is similar to @Special-K suggestion
"Icons" in column B are letters "s" to "z" using font Windings3
Formula in B2 copied down:
Formula:
Please Login or Register to view this content.
Then conditional formatting applied to column B determines font colour
ConditFormat125.jpg
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
OR:
simply conditionally "fill" cell in column B based on value in columnA
(avoids creating a lookup table and using fonts)
- see sheet1 in attached workbook
uses a separate colour fill rule for each band of 100 numbers
rules are applied in sequence and so each rule is a simple "> than"
(so do not need > than 0 and < than 101)
ConditFormat127.jpg
ConditFormat128.jpg
rules:
ConditFormat129.jpg
Last edited by kev_; 06-30-2017 at 07:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks