Hi all,
I have a cell in one tab (we will call tab 1) with a formula in it that presents the data like this: 232 +126.9%. The formula to get this data pulls data from other tabs within the sheet and separates a value and calculates the percentage increase from last year.
I need to conditional format the cell. In tab 2 I have pulled the "232" value and then next to it created tolerance intervals. I need to use the 5 arrow icon set and have been trying to get it to look at the cell in tab 2 to format tab 1.
Nothing appears to happen.
Any help would be appreciated!
Thanks in advance!
I have a cell in one tab (we will call tab 1) with a formula in it that presents the data like this: 232 +126.9%. The formula to get this data pulls data from other tabs within the sheet and separates a value and calculates the percentage increase from last year.
I need to conditional format the cell. In tab 2 I have pulled the "232" value and then next to it created tolerance intervals. I need to use the 5 arrow icon set and have been trying to get it to look at the cell in tab 2 to format tab 1.
Nothing appears to happen.
Any help would be appreciated!
Thanks in advance!