revolverpow
New Member
- Joined
- Feb 4, 2016
- Messages
- 5
Hi All,
I can't get my head around this.
<tbody>
</tbody>
So I have my A-B-C store and the expectation are different for all of them in terms of condition.
Right now, I'm doing manually, but I'd like it to be automated.
So when I enter the %conversion, I want it to switch between red-yellow-green depending if it meets the targets.
My problem if having A-B-C store with different expectations and I really don't know how to apply a conditionnal formatting, considering if it's an A-B-C store AND considering the %conversion.
Here are my expectation for A-B-C; the X represent the value in %Conversion column.
<tbody>
</tbody>
Can someone help me build the right formula for this ?!
Thank you all (and sorry for the bad english) !
I can't get my head around this.
A-B-C Store | %Conversion |
A | 9,2% |
B | 7,50% |
C | 9,0 |
<tbody>
</tbody>
So I have my A-B-C store and the expectation are different for all of them in terms of condition.
Right now, I'm doing manually, but I'd like it to be automated.
So when I enter the %conversion, I want it to switch between red-yellow-green depending if it meets the targets.
My problem if having A-B-C store with different expectations and I really don't know how to apply a conditionnal formatting, considering if it's an A-B-C store AND considering the %conversion.
Here are my expectation for A-B-C; the X represent the value in %Conversion column.
Store | RED | YELLOW | GREEN |
A | X>9% | 9%=>X<11% | 11%=>X |
B | X>9% | 9%=>X<11% | 11%=>X |
C | X>9% | 9%=>X<11% | 11%=>X |
<tbody>
</tbody>
Can someone help me build the right formula for this ?!
Thank you all (and sorry for the bad english) !