MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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).


Posted by Oscar on October 06, 2000 12:40 PM

That was quick and easy - thanks!