ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula not displaying colored border when double clicked (https://www.excelbanter.com/excel-discussion-misc-queries/128906-formula-not-displaying-colored-border-when-double-clicked.html)

Joker

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