Get instant live Excel expert help to learn how to apply conditional formatting to an icon set in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I'm using conditional formatting icon sets, and the icons are appearing to be wrong based on the percentage.
Solved by I. C. in 12 mins
I would like to use conditional formatting and icon sets for:
Dates between today and 3 years - green tick
Dates 60 days before expiry (3 years) - yellow exclamation mark Dates after 3 years - red cross)
Please note that Column A has the date the training was done and Column B has a formula which adds 3 years to the date in Column A. I know that I can conditionally format the cells in Column B by using colours only, but I would like to add the icons for a more visual cue.
Solved by I. S. in 25 mins
Hello. Looking at Excel Conditional Formatting using ICON Sets. I would like to use four Icons not just three. Is that possible?
Solved by Z. C. in 25 mins
Conditional formatting with Icon Sets using percentiles. Check my work do you agree the arrows are setup properly on CF6.1, and how do I get 4 arrows to show instead of 3 on the next tab.
Solved by F. H. in 11 mins