Conditional Statements with Formatting

[lmc_budd]

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]

Budd,

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

 

[lmc_budd]

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]

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!