Help with Excel text formatting within a function

[bigkeith]

Hello all,
I have written an IF function in excel and would like some control over the resulting text display. The function checks to see if a number has been entered in one cell before performing a calculation. If no number has been entered, then a text message is displayed in the cell. Is it possible to alter the format of the resulting text, eg change the colour or make it bold? Here is an example of the function:

=IF(ISNUMBER(I3),(M3/1000)*(I3-J3),"Coil Weight?&quot


I was hoping to add a character code to the text, eg
chr(nn)&"Coil Weight" - where nn would be the corect code for Bold.

Am I barking up the wrong tree - or just barking?

Thanks in advance

Keith

 

[Bowers74]

Set the conditional Formatting for that cell to become bold (or whichever format you want) if the cell's Value = "Coil Weight"



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Bowers74]

You cant change a cells format using a function! You have to go to Format->Conditional Formatting... and set the format you want the cell to have if it's value is equal to your criteria. You can set up to three criteria. If you need more, then you will (more than likely) have to go the VBA route.

I hope this helps!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[bigkeith]

Thanks Mike, that does the trick perfectly.

Keith

 

[Bowers74]

Glad I could help!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!