'In this example it starts in cell Q202 and compares to the cell Q210 and does this for 5 rows and 9 columns. The main block of code is below, but you can see more detail on my website at Sub CompareIcons() In the end, I wrote a generic macro to enable icon comparison between two data sets and apply the whole lot to a range. I just don't know how to go about doing that What I would like is something equivalent to: =OR(TODAY()+7-D$14,D$12=100) The code that is being used as a condition is: =OR(TODAY()+7-$D$14,$D$12=100) otherwise show an x when the current day is the same as the target date and the cell's value is not 100% If there are less than 7 days between the target date and current date then it will show an exclamation mark.
The cell will show a checkmark so long as there is at least a week before the target date or if the cell reads 100%. Excel is telling me that I'm not able to use relative referencing with icon sets.įor clarification, what I'm trying to do is apply an icon set based on the relation between the current day and the target date of a project to be completed. Ideally I would like to lock the row whilst allowing the column to change as the column is copied and pasted across the worksheet (ex.
I was wondering if there is any way to use relative referencing with icon sets in excel.