msvictorialc
New Member
- Joined
- Jul 4, 2015
- Messages
- 4
Good morning, Conditional formatting with multiple conditions... How do I enter a formula in the conditioning function to create the result I am looking for below.
Factors involved
Column A value = percentage value between 10% - 30%
Column L value = "Y" or "N" (any time this cell value in Column L = "Y", I want Column E cell color to change to Orange
Column E Value = percentage value --> identifying if Column A is greater than 20% and if Column L = "N", Change the Cell Color to Blue and reduce the % to 20%
i.e. What is the correct VBA Code or add the Conditional Formatting formula to use to achieve result below?
Factor Examples
A1 = 19%, L1 = N --> Result E1 = 19% (no cell color)
A2 = 24%, L2 = N --> Result E2 = 20% (Cell Color Blue)
A3 = 22%, L3 = Y --> Result E3 = 22% (Cell Color Orange)
A4 = 15%, L4 = Y --> Result E4 = 15% (Cell Color Orange)
=IF(AND(L1="N",E1>20%),E1=A1) ----> Leave Cell without color
=IF(AND(L2="N",E2>20%),E2=20%) --> Change Cell Color to Blue
=IF(AND(L3="Y",E3>20%),E3=A3) ----> Change Cell Color to Orange
=IF(AND(L4="N",E4>20%),E4=A4) ----> Change Cell Color to Orange
I appreciate any direction to achieve this conditioning result.
Factors involved
Column A value = percentage value between 10% - 30%
Column L value = "Y" or "N" (any time this cell value in Column L = "Y", I want Column E cell color to change to Orange
Column E Value = percentage value --> identifying if Column A is greater than 20% and if Column L = "N", Change the Cell Color to Blue and reduce the % to 20%
i.e. What is the correct VBA Code or add the Conditional Formatting formula to use to achieve result below?
Factor Examples
A1 = 19%, L1 = N --> Result E1 = 19% (no cell color)
A2 = 24%, L2 = N --> Result E2 = 20% (Cell Color Blue)
A3 = 22%, L3 = Y --> Result E3 = 22% (Cell Color Orange)
A4 = 15%, L4 = Y --> Result E4 = 15% (Cell Color Orange)
=IF(AND(L1="N",E1>20%),E1=A1) ----> Leave Cell without color
=IF(AND(L2="N",E2>20%),E2=20%) --> Change Cell Color to Blue
=IF(AND(L3="Y",E3>20%),E3=A3) ----> Change Cell Color to Orange
=IF(AND(L4="N",E4>20%),E4=A4) ----> Change Cell Color to Orange
I appreciate any direction to achieve this conditioning result.