![]() |
Formula not displaying colored border when double clicked
I have this formula which works the way I want except when I double click the
formula, it does not show the colored border around the cells in the formula so I can quickly drag the formula to change it when I need to. Is there something I am doing wrong which would prevent excel from doing this? I have an almost exact same formula (bottom) which does show me the colored borders. Any help would be appreciated. =IF($D2=13328000,IF($G21199.99,$J5-$J2,$J4-$J2),IF($D2=13328100,IF($G21199.99,$J5-$J2,$J4-$J2),IF($D2=13328200,IF($G21199.99,$J5-$J2,$J4-$J2),IF($D2=13280300,$J5-$J2,IF($D2=13288100,$J3-$J2,IF($D2=13280800,$J4-$J2,IF(($D2=13286500)*($D1=10051202),$J3-$J1,IF($D2=13286500,$J4-$J2,"")))))))) =IF($D2=13328000,$J3-$J2,IF($D2=13328100,$J3-$J2,IF($D2=13328200,$J3-$J2,IF($D2=13280300,$J3-$J2,IF($D2=13280800,$J3-$J2,IF(($D2=13286500)*($D1=10051202),$J1-$J2,IF($D2=13286500,$J3-$J2,""))))))) |
All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com