Conditional formatting in if statement

srmorgan · May 13th, 2002, 07:52 AM

Can I insert conditional formatting in an if statement? For example if (b5>b6, b5, "out of balance") with the phrase out of balance printed bold and in red?

Thanks to all

Audiojoe · May 13th, 2002, 08:00 AM

You cant do it within the formula

Just do the formula as normal, then highlight the cell and go into conditional formatting as usual. Make the condition Equal To and then just type Out Of Balance in the field and set the required format

Audiojoe

[ This Message was edited by: Audiojoe on 2002-05-13 07:01 ]

srmorgan · May 13th, 2002, 08:35 AM

Thanks, Joe.

Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 07:52 AM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	Can I insert conditional formatting in an if statement? For example if (b5>b6, b5, "out of balance") with the phrase out of balance printed bold and in red? Thanks to all

May 13th, 2002, 08:00 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	You cant do it within the formula Just do the formula as normal, then highlight the cell and go into conditional formatting as usual. Make the condition Equal To and then just type Out Of Balance in the field and set the required format Audiojoe [ This Message was edited by: Audiojoe on 2002-05-13 07:01 ]

May 13th, 2002, 08:35 AM	#3
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	Thanks, Joe. Steve