If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
More than 3 Conditions
Hi, I am looking for a code which will do the following for me
Range is T5:T90 Condition 1: If Cell value is 10 make background light blue Condition 2: If cell value is between -10% and -20% make background yellow Condition 3: If cell value is -20% make background red Condition 4: If cell value is 10% but 0% make background green. |
#2
|
|||
|
|||
More than 3 Conditions
Excel 2003
Sub cus Dim cell as Range For Each cell in Range("T5:T90").Cells If cell.Value10 Then cell.Interior.ColorIndex = 8 Elseif cell.Value=20% and cell.Value=10% Then cell.Interior.ColorIndex = 6 Elseif cell.Value20% Then cell.Interior.ColorIndex = 3 Elseif cell.Value0 and cell.Value10% Then cell.Interior.ColorIndex = 50 End If Next cell End Sub On 20 Lis, 14:31, John Moore wrote: Hi, I am looking for a code which will do the following for me Range is T5:T90 Condition 1: If Cell value is 10 make background light blue Condition 2: If cell value is between -10% and -20% make background yellow Condition 3: If cell value is -20% make background red Condition 4: If cell value is 10% but 0% make background green. |
#3
|
|||
|
|||
More than 3 Conditions
Since your conditions cover all possible values of the cells you can "fake"
the 4th condition. Set conditional formats for condtions 2, 3, and 4. Make the natrual fill color of the cells light blue. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "John Moore" wrote: Hi, I am looking for a code which will do the following for me Range is T5:T90 Condition 1: If Cell value is 10 make background light blue Condition 2: If cell value is between -10% and -20% make background yellow Condition 3: If cell value is -20% make background red Condition 4: If cell value is 10% but 0% make background green. |
Thread Tools | |
Display Modes | |
|
|