| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If / Then based off conditional format
Is there VB code that will let me do the following:
If the cell is color green (turns green from conditional format) Then paste this formula into it "=IF(AC23=J23,J23*0.5,IF(D23=" ",VLOOKUP(C23,'2006 IP Payer Mix on Settled'!H:I,2,FALSE)*K23,IF(B23="A",VLOOKUP(D23,' 2006 IP Template'!B:C,2,FALSE),IF(B23="B",VLOOKUP(D23,'200 6 IP Template'!B:G,6,FALSE),IF(B23="h",VLOOKUP(C23,'200 6 IP Payer Mix on Settled'!H:I,2,FALSE)*K23,IF(B23="d",VLOOKUP(D23,' 2006 IP Template'!B:Y,10,FALSE),IF(C23="D05",VLOOKUP(D23,' 2006 IP Template'!B:Y,11,FALSE))))))))" Or If the cell is color yellow (turns yellow from conditional format) Then paste this formula into it "=IF(AC1550=J1550,J1550*0.5,IF(D1550=" ",VLOOKUP(C1550,'2007 IP Payer Mix on Settled'!H:I,2,FALSE)*K1550,IF(B1550="A",VLOOKUP(D 1550,'2007 IP Template'!B:C,2,FALSE),IF(B1550="B",VLOOKUP(D1550, '2007 IP Template'!B:G,6,FALSE),IF(B1550="h",VLOOKUP(C1550, '2007 IP Payer Mix on Settled'!H:I,2,FALSE)*K1550,IF(B1550="d",VLOOKUP(D 1550,'2007 IP Template'!B:Y,10,FALSE),IF(C1550="D05",VLOOKUP(D15 50,'2007 IP Template'!B:Y,11,FALSE))))))))" In advance thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format based on sub-string | Excel Discussion (Misc queries) | |||
| Conditional Format Based on Date | Excel Worksheet Functions | |||
| Conditional Format a row based on a cell? | Excel Worksheet Functions | |||
| Conditional Format based on other cell | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
Threaded Mode
