Format Individual Cells In a Range of Columns
Posted by Oscar on October 06, 2000 10:25 AM
Hi there.
I want to automatically (on input) bold the font of
a cell only if its value <> 0.
The cells are part of a range.
What's the best way?
thanks.
Posted by Tim Francis-Wright on October 06, 2000 12:14 PM
In Excel 97 or 2000, use Conditional Formatting
(under the Format menu).
Set Condition 1 to be Cell Value <> 0
then under Format, select Font style to be bold.
N.B.: In Excel 95, you'll need to set up a macro
that works with Worksheets("sheetnamehere").Onentry
by setting up the .Onentry property in an
auto_open sub).
HTH
Posted by Oscar on October 06, 2000 12:40 PM
That was quick and easy - thanks!
