IF Function to change font

  • Thread starter Thread starter peter d
  • Start date Start date
P

peter d

Hi,

I can nearly do this but not quite.

I am using a spreadsheet to generate bar codes for
release notes on a transport manifest. I want to make
sure that duplicates are not entered so want to use an if
function to check before creating the bar code.

The function I have is:

=IF((COUNTIF(C:C,C8))>1,"Duplicated","*"&C8&"*")

If the count is greater than 1 it prints 'duplicated'
which is what I am after - but it prints in the bar code
font.

How can I get it to change the font for dupicated to
print in, say, Arial? I seem to remember a Format or Font
function but can't find it anywhere.

Any help would be much appreciated.

Peter
 
You can do what you want with Conditional Formatting. Enter Format / Conditional Format, then in the dialog box you want to select Cell Value is Equal to "Duplicated", then format to Ariel or whatever. Then, if you set the format for the releant cell as your barcode font, it will either show the code, or "Duplicated" in Ariel.
 
Hi Vaughan
unfortunately you can't change the font type within the conditional
format dialog. So this solution won't work
 
mmm ...

You're right, of course, Frank. The Modify Format selection shows the Format Font dialog, but won't let you change it. I looked to confirm it was there before I posted my advice, but didn't try to change the font.

That'll teach me.

Sorry peter, ignore my advice.
 
Back
Top