conditional formatting + VBscript
 

I have cells that automatically Bold and Underline the employees who met
their goals in each category, but I want to make the font bigger in these
cells. I know Excel doesnt do this, but I was hoping somebody could make a
function for me that would take a true/false value & if it returns TRUE then
it would do fontsize + 2.

I know this is possible in VBscript but I have no clue how to program can
somebody please help me?

conditional formatting + VBscript
 

You no need VBscript all you need Conditional Formatting

"John C" wrote:

I have cells that automatically Bold and Underline the employees who met
their goals in each category, but I want to make the font bigger in these
cells. I know Excel doesnt do this, but I was hoping somebody could make a
function for me that would take a true/false value & if it returns TRUE then
it would do fontsize + 2.

I know this is possible in VBscript but I have no clue how to program can
somebody please help me?

conditional formatting + VBscript
 

Mama

You can't change Font Size using CF.......color, style, underline and
strikethrough only.


Gord Dibben MS Excel MVP

On Sat, 23 Dec 2006 11:15:00 -0800, Teethless mama
wrote:

You no need VBscript all you need Conditional Formatting

"John C" wrote:

I have cells that automatically Bold and Underline the employees who met
their goals in each category, but I want to make the font bigger in these
cells. I know Excel doesnt do this, but I was hoping somebody could make a
function for me that would take a true/false value & if it returns TRUE then
it would do fontsize + 2.

I know this is possible in VBscript but I have no clue how to program can
somebody please help me?