Format formula

[MAXWELL]

Dear GURU,

I need write a formula that says....If cell A1="Apple",
then give me cell B1 which will be BOLDED and UNDERLINED,
otherwise give me C1 in ITALICS.

So if A1=Apple, then B1 is pulled. B1 = Green.
B1 then must be pulled where the workd Green will be
bolded and underlined.

I do not want to use VB coding.

Can you help?

 

[Myrna Larson]

Let's say the cell you are talking about is D1. The formula should be

=IF(A1="Apple",B1,C1)

Then set up conditional formatting for this cell
Select Formula Is from the 1st dropdown
The 1st formula is =$A$1, format is bold and underlines
The 2nd formula is =$B$1, format is italics

 

[Maxwell]

Yes that is one way, however I wanted to see if there was
an actual formula that would give me the same results.

 

[hgrove]

Maxwell wrote...

Yes that is one way, however I wanted to see if there was an
actual formula that would give me the same results.

...

No. Formulas *only* return values to their cells. They do nothing else
not even formatting. Conditional formatting or macros are the only wa
to do what you want to do

 

[Myrna Larson]

Formulas calculate a result. They don't change formatting.