ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ISO smallest passive / do nothing formula for formatting null.. (https://www.excelbanter.com/excel-discussion-misc-queries/111943-iso-smallest-passive-do-nothing-formula-formatting-null.html)

nastech

ISO smallest passive / do nothing formula for formatting null..
 
just trying to make header lines with top / bottom lines. Problem with
conditional formatting for "not" needing any result in a formula, that might
corupt / take space.. etc. would use something like =CELL() if that were
valid.
Is there a variation on that?

else smallest / non-dependant would have cell = itself :), not what want? but:
=A1

any suggestions would help.. maybe this is something excel could account
for..
thanks
(just using top / bottom border direct ~"corrupts data lines that end up
with unwanted borders...)


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com