Conditional Statements with Formatting

lmc_budd · May 1st, 2002, 07:34 AM

Using Excel 2000, how can I include formatting in cells that contain conditional statements?
eg =IF(A1=0,"fa","fb") where the characters 'a' and 'b' are a suffix, bold, or different fonts, etc.

Brian from Maui · May 1st, 2002, 09:38 AM

Budd,

You only want a or b to be formatted and not fa or fb by conditional formatting?

lmc_budd · May 1st, 2002, 09:50 AM

Its not important how much of the text is formatted, as this is only an example. However, whatever the solution proves to be, it must also work when the sheet is protected.

Yogi Anand · May 1st, 2002, 09:55 AM

Quote:

On 2002-05-01 06:34, lmc_budd wrote:
Using Excel 2000, how can I include formatting in cells that contain conditional statements?
eg =IF(A1=0,"fa","fb") where the characters 'a' and 'b' are a suffix, bold, or different fonts, etc.

try
=OR(A1=0,A1="fa",A1="fb")
Hope This Helps!

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

May 1st, 2002, 07:34 AM	#1
lmc_budd New Member Join Date: Apr 2002 Location: London, UK Posts: 34	Using Excel 2000, how can I include formatting in cells that contain conditional statements? eg =IF(A1=0,"fa","fb") where the characters 'a' and 'b' are a suffix, bold, or different fonts, etc.

May 1st, 2002, 09:38 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Budd, You only want a or b to be formatted and not fa or fb by conditional formatting?

May 1st, 2002, 09:50 AM	#3
lmc_budd New Member Join Date: Apr 2002 Location: London, UK Posts: 34	Its not important how much of the text is formatted, as this is only an example. However, whatever the solution proves to be, it must also work when the sheet is protected.