In Excel 2007, I would like to show an icon based on the value in another cell.
For example:
If B1 > A1, show a green up arrow in B1
If B1 = A1, show a yellow sideways arrow in B1
If B1 < A1, show a red down arrow in B2
And repeat the rule for B2 & A2, B3 & A3, etc.
This seems so simple but the rules available for icon sets seem limited to fixed thresh holds, and absolute references.
What am I missing?
The icon sets are used to compare cells in a select range.. not compare to specific cells. Also you can reference cells with this option.
You will need to apply format the font or background the appropriate colours... or you can use a formula in a separate cell (column) that returns wingding symbols based on condition, then format those cells.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks