Hi all,
I currently have a conditional format on a cell to turn yellow when the value of an adjacent cell exceeds a certain value. What I would like is for the cell to stay the same color after the conditional format is triggered even if the value is no longer exceeded.
Example:
I want cell B:1 to light yellow when cell A:1 is greater than 1, however after refreshing data, the value of cell A:1 is now .5, but I want B:1 to remain yellow. Then I would need some sort of reset procedure. Can this be done with conditional formatting and if so, how???
Thanks in advance.
I currently have a conditional format on a cell to turn yellow when the value of an adjacent cell exceeds a certain value. What I would like is for the cell to stay the same color after the conditional format is triggered even if the value is no longer exceeded.
Example:
I want cell B:1 to light yellow when cell A:1 is greater than 1, however after refreshing data, the value of cell A:1 is now .5, but I want B:1 to remain yellow. Then I would need some sort of reset procedure. Can this be done with conditional formatting and if so, how???
Thanks in advance.