Hello,
I am looking to use conditional formatting (in the form of up/down/right arrow icon sets) to determine if the current month's performance (Tab: April) is better, worse, or the same as the previous month's performance (Tab: March).
For example, I have multiple metrics for each of my sales people. The data that appears in the April tab is listed in the same order on the March tab.
I have been able to identify the current month's performance relative to the prior month using this formula in an adjacent cell:
=IFERROR(((K5/'March'!K5)-1),0)
Also, I am using this for my icon set conditional formatting in that same adjacent cell:
Up arrow is 'when value is >= 0.0001 (Number)
Right arrow is 'when < 0.0001 (Number)
Down arrow is "when < 0
What I am looking to do is have the same formatting appear in the SAME cell as the current month's data, rather than in the cell adjacent to it.
I am unsure if this is possible, and appreciate any guidance anyone is able to provide.
Thank you in advance!
A
I am looking to use conditional formatting (in the form of up/down/right arrow icon sets) to determine if the current month's performance (Tab: April) is better, worse, or the same as the previous month's performance (Tab: March).
For example, I have multiple metrics for each of my sales people. The data that appears in the April tab is listed in the same order on the March tab.
I have been able to identify the current month's performance relative to the prior month using this formula in an adjacent cell:
=IFERROR(((K5/'March'!K5)-1),0)
Also, I am using this for my icon set conditional formatting in that same adjacent cell:
Up arrow is 'when value is >= 0.0001 (Number)
Right arrow is 'when < 0.0001 (Number)
Down arrow is "when < 0
What I am looking to do is have the same formatting appear in the SAME cell as the current month's data, rather than in the cell adjacent to it.
I am unsure if this is possible, and appreciate any guidance anyone is able to provide.
Thank you in advance!
A