Which is the Best Methord do you Think!

[Bob Vance]

=IF(DU86=0,"","Balance for the Month Ending:")
or
Conditional Formatting > =DU86=0 > White color Font
Does Conditional Formatting copy to anther excel?
--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Norman Harker]

Hi Bob!

My personal preference is for formula approach rather than hiding the
answer by conditional formatting. Apart from reluctance to hide, the
formula approach allows subsequent easier use of formulas on the cell.

Yes! Conditional Formats are copied to another cell.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.